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)