SQL Server Performance Forum – Threads Archive
sql server 2000 backup and restoreI 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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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.