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: tshinder@isaserver.org
MVP — Microsoft Firewalls (ISA)
mark graves Says:
August 17th, 2007 at 8:27 am
I want to change my logging location from the default ISA logs folder to a second drive in the same server. I have created the folder and set permissions as described above.
Must I first detach and copy the existing database files before changing the logging location in the MSDE logging parameters?
Thanks.