homepage Welcome to WebmasterWorld Guest from 54.198.8.124
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
Can I create a local backup of a MS SQL 2000 database?
Just took the big jump from MS Access...
HyperGeek




msg:956951
 4:33 am on Feb 2, 2005 (gmt 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.

 

skipfactor




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

Probably better/easier ways, but I create a local SQL server and export the data from the remote to local.

Easy_Coder




msg:956953
 4:53 am on Feb 2, 2005 (gmt 0)

Take a look in BOL. Search on Backup in the Index Search.

Jimmy Turnip




msg:956954
 9:46 am on Feb 2, 2005 (gmt 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?

aspdaddy




msg:956955
 10:17 am on Feb 2, 2005 (gmt 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.

HyperGeek




msg:956956
 3:05 pm on Feb 2, 2005 (gmt 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. :(

dotme




msg:956957
 8:59 pm on Feb 2, 2005 (gmt 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...

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved