MS SQL Server - RE: Can I move System database log files?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

RE: Can I move System database log files?

SkyWalker

2005-05-31, 8:23 pm

There is how to move user DBs as well as system DBs and trans logs
between devices.

Regards.

"Jerame" wrote:

> I am trying to improve performance on my sql server by moving the log files
> to a different drive than my mdf files. I have done this sucessfuly with my
> user databases, but wanted some reassurance before trying the system
> databases (i.e. Master, Model, MSDB and TempDB). I have done this with a
> detach, and a attach database from Enterprise Administrator (I'm not actually
> a dba ).
>
> Is there a recommened method (if it's possible) to move the log files of the
> system databases?
>
> TIA,
> Jerame

Sponsored Links