Deploysrs Posted June 21, 2008 Share Posted June 21, 2008 I have SQL 2000 server running on a Windows 2003 Server. I have a few web sites on the same server that is connected to SQL 2000. My Question is I would like to back up each DB at a time and then store it on Tape or DVD for safe keeping. That way just incase the server crashes or if I want to move a DB to a different server later I could do so. If some one could give me a easy step by step on how to backup each DB that would be great. I just want to make sure if I ever restored a DB it would work. Thanks Link to comment Share on other sites More sharing options...
CoffeeFiend Posted June 21, 2008 Share Posted June 21, 2008 I could go on about all this for quite a while... But here's the short answer: download the latest BOL for SQL Server 2000. There should be a section called "Backing Up and Restoring Databases in SQL Server". You can also peek at this technet article. Loads of ways to do it. BTW, you can use a simple BACKUP DATABASE T-SQL statement (then schedule it to run), just look it up.Any specific questions, just ask. Link to comment Share on other sites More sharing options...
Deploysrs Posted June 21, 2008 Author Share Posted June 21, 2008 Thanks so much crahak that info was very helpful. I found what I needed by going to that technet artical on SQL 2000 you gave me. Thanks So much!!!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now