sql server 2000 backup and restore | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql server 2000 backup and restore

I have been working with sql server 2000 for about 4 months. My small company will not be converting to sql server 2005 until the end of 2006. I need setup backup and restore procedures for a sql server 2000 database. Can you point me to an example t-sql script and/or a url that I can use as a reference for settting up backup and restore procedures for a sql server 2000 database? Thanks!
You can read BOL (Books on Line) search: BACKUP and RESTORE and you will find what you need with examples too.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
http://weblogs.sqlteam.com/tarad Look at the SQL Server Administration category. She has scripts you can use. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
]]>