SQL Server Performance Forum – Threads Archive

Maintenance Plan

hi gurus, are they any gurus here have a brilliant backup procedure that can share with DBA here. tq in advance.

This is a very broad question and it really depends on your needs. I would suggest reading up some articles or BOL on backup and restore procedures, and then if you have any specific questions on a particular method, then ask . This link will give you a place to start:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

If you are looking for ‘Something more’* then usual backup/restore policy using 3rd party products, then consider a trail for: – http://www.red-gate.com/products/sql_backup/ * Encryption, Compression, faster, simpler and secure. Deepak Kumar –This posting is provided â€œAS ISâ€ with NO rights for the sake of knowledge sharing.

Also refer
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k Madhivanan Failing to plan is Planning to fail

]]>