Back up of MSSql Database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Back up of MSSql Database

Can anyone tell me the procedure of taking backup of MS Sql server2k db.i ve created one db in sql server 2k, of which i ve to take back up every day or may be should i take the back up of it?
You can check out the explanations to BACKUP and RESTORE in BOL and schedule your script as a job. But probably it’s easier to use the Maintenance Plan Wizard. —

Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Ich unterstütze PASS Deutschland e.V.

Create Procedure BackUpDB
Backup database yourDB to disk=’path’ Schedule this as job to run periodically Madhivanan Failing to plan is Planning to fail
Again, you are fast Frank [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Sorry! [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />–<br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=></a><br />Heute schon gebloggt?<a target="_blank" href=></a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=></a>)
in addition to backing up your db,
always restore the backup on a test server.
do not reply on the backup with verify, or the restore with verify only