Jump to content

Sql 2000 Server


Recommended Posts

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 :thumbup

Link to comment
Share on other sites


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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...