Change location of log files for system databases

[GJP55]

I would like to change the location of the log files on our systen databases, does anybody know how to do this or is it possible once past the initial install of the database ?

 

[Taffyboyo]

Backup the database then restore it. On the restore window 'Options' tab it allows you to change the location of both the database and the log files.

 

[GJP55]

excellent, thanks for your reply.

 

[mrdenny]

Why are you looking to change the path of the log files for the system databases. The system databases are all in simple mode and there logs are rarly used.

The backup and restore method mentioned will be a pain for the system databases, and restoring system databases isn't as simple as just restoring the databases.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[GJP55]

We have our msbd in full mode. We do a lot of work with dts's. Reason why we want to change the path is becuase mdf and ldf files for these database are on the same drive. Though it would be better to have them on seperate drives.

 

[mrdenny]

Doing a lot of work with DTS doesn't mean that you need to have the msdb is full recovery mode. The reason to have a database in full recovery mode is so that you can do transaction log backups, and to be able to restore to a point in time. I wouldn't want to restore the msdb database to a point in time, as who knows what would happen if a dts package was being saved during the time frame that you stop the restore at. A half saved package could screw up a lot of stuff.

Here are the steps to move msdb file(s).
First, right-click the SQL-Server name and click properties. From the General tab, choose your startup parameters. Next, enter the parameter -T3608. Click OK, stop and restart SQL Server. After the restart, detach the database and move them to their appropriate place. After the database is reattached, remove the parameter -T3608 and restart the service again.

Denny

--Anything is possible. All it takes is a little research. (Me)