SQL Server Performance Forum – Threads Archive

Back up of MSSql Database

Hi,
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 weekly.how 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
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Create Procedure BackUpDB
as
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=’

‘ />] Madhivanan Failing to plan is Planning to fail

Sorry! [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] – – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</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

]]>