Welcome to WebmasterWorld Guest from 23.22.220.37

Forum Moderators: ocean10000

Message Too Old, No Replies

Can I create a local backup of a MS SQL 2000 database?

Just took the big jump from MS Access...

     
4:33 am on Feb 2, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:May 8, 2002
posts:390
votes: 0



It wasn't as bad as I thought it would be. The only thing that I miss horribly is how I used to be able to download and backup my MS Access DBs.

Is there any way to do this with MS SQL 2000? I'm using the Enterprise Manager, but all I'm finding are tutorials on migrating to another SQL server. :(

I sure hope I can backup my own database. It would seem a bit ridiculous not to be able to take that liberty.

4:36 am on Feb 2, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 22, 2003
posts:1483
votes: 0


Probably better/easier ways, but I create a local SQL server and export the data from the remote to local.
4:53 am on Feb 2, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 2, 2003
posts:1184
votes: 0


Take a look in BOL. Search on Backup in the Index Search.
9:46 am on Feb 2, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 18, 2003
posts:146
votes: 0


Right click the db name in enterprise manager, then select all tasks --> backup database. You can then create a local backup of the database where-ever you like.

Is this what you wanted to do?

10:17 am on Feb 2, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


You just need to backup the data(.mdf) and transaction log (.ldf) files each day.

If you right click on the db and select properties, you can find the locations of these files.

3:05 pm on Feb 2, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:May 8, 2002
posts:390
votes: 0


Right click the db name in enterprise manager, then select all tasks --> backup database. You can then create a local backup of the database where-ever you like.

It won't let me do this. :(

8:59 pm on Feb 2, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Nov 25, 2003
posts:107
votes: 0


You can write a batch file that shuts down SQL, copies out the mdf and ldf files and restarts SQL - 2 minutes of downtime. Not terrible if you run it as a scheduled task at 3am...
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members