Page is a not externally linkable
-- Microsoft IIS Web Server and ASP.NET
---- Can I create a local backup of a MS SQL 2000 database?
dotme - 8:59 pm on Feb 2, 2005 (gmt 0)Thread source:: http://www.webmasterworld.com/microsoft_asp_net/2447.htm
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...
Brought to you by WebmasterWorld: http://www.webmasterworld.com