Welcome to WebmasterWorld Guest from 54.197.171.28

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)

10+ Year Member




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)

WebmasterWorld Senior Member 10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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

10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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)

10+ Year Member



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)

10+ Year Member



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