Moving MSDE Log Files

If you need to copy MSDE log files from one location to another, or to move the files to another server, you must first detach the database from the current server. You should never detach a database that is currently in use. One way to determine whether a database is in use is to verify that the date included in the file name is a past date or that a database with a higher number exists for the current date. Another way is to enter the following lines at command prompts:

OSQL -S computer_name\MSFW -E

sp_who2

go

This will list all MSDE databases that currently have open connections, and show which application and user has them locked or is using them.

To detach a database from a server, enter the following lines at command prompts:

OSQL -S computer_name\MSFW -E

sp_detach_db database_name

go

quit

HTH,

Tom

Thomas W Shinder, M.D.
Site: www.isaserver.org

Blog: http://blogs.isaserver.org/shinder/
Book: http://tinyurl.com/3xqb7

Email: [email protected]

MVP — Microsoft Firewalls (ISA)

Leave a Comment

Your email address will not be published.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top