homepage Welcome to WebmasterWorld Guest from 54.237.213.31
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

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

10+ Year Member



 
Msg#: 2447 posted 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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 2447 posted 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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 2447 posted 4:53 am on Feb 2, 2005 (gmt 0)

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

Jimmy Turnip

10+ Year Member



 
Msg#: 2447 posted 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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 2447 posted 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

10+ Year Member



 
Msg#: 2447 posted 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

10+ Year Member



 
Msg#: 2447 posted 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