all groups > sql server (alternate) > september 2006 >
You're in the

sql server (alternate)

group:

Question on moving logs


Question on moving logs DataPro
9/21/2006 6:44:56 AM
sql server (alternate):
Running SQL Server 2000. I have been asked to move the transaction logs
to another drive. I was able to do that for the user databases using
detach/attach.

However I don't see that as an option for moving the logs for the
system databases.
Is there any way I can move the system database logs? I'm guessing it
might be possible through a restore.

Any thoughts ?

Thanks in advance.

Gerry
Re: Question on moving logs Jens
9/21/2006 7:39:25 AM
Shutdown the service, and change thew appropiate registry settings for
the temp and the master database. The other databases can be moved with
attach / detach.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---
Re: Question on moving logs DataPro
9/21/2006 10:23:32 AM

[quoted text, click to view]

Thanks Jens

Also came across this

http://support.microsoft.com/kb/224071/
AddThis Social Bookmark Button