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

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.

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!!!!!!