March 7, 2012 at 2:37 pm
I have a new Standard SQL Server 2008 R2 cluster and I need to move the log files to a different drive. How do I move the master, model, msdb, and tempdb log files from drive F to drive G? Thanks for your help.
March 7, 2012 at 3:39 pm
http://msdn.microsoft.com/en-us/library/ms345408.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2012 at 4:07 pm
I would ask why? Master and model are hardly updated, msdb not much more so why bother splitting out the log?
You can a make a case for tempdb and thats just done with an alter database and SQL restart.
save yourself the risk and outage and don't bother with the other databases.
---------------------------------------------------------------------
March 8, 2012 at 1:09 am
george sibbald (3/7/2012)
I would ask why? Master and model are hardly updated, msdb not much more so why bother splitting out the log?You can a make a case for tempdb and thats just done with an alter database and SQL restart.
save yourself the risk and outage and don't bother with the other databases.
Good point, but I think the OP just wanted to move the files to a different drive, not split them.
-- Gianluca Sartori
March 8, 2012 at 3:01 am
Gianluca Sartori (3/8/2012)
george sibbald (3/7/2012)
I would ask why? Master and model are hardly updated, msdb not much more so why bother splitting out the log?You can a make a case for tempdb and thats just done with an alter database and SQL restart.
save yourself the risk and outage and don't bother with the other databases.
Good point, but I think the OP just wanted to move the files to a different drive, not split them.
thats what I mean by splitting the files, separating the log and data files for the system dbs, its just not worth it except for tempdb
---------------------------------------------------------------------
March 8, 2012 at 6:43 am
This was a new install and we have no user databases as of yet, however when we installed SQL we didn't split them up. As for why, just trying to keep the logs in place and the data files in another. There really isn't any risk right now so I thought I would get this done before we go live with the cluster.
March 8, 2012 at 6:57 am
Logs are generally separated from data files for performance reasons, there is no performance benefit in separating system db data and log as they are not updated enough. My advice to you would be to keep it simple and leave them as they are.
---------------------------------------------------------------------
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply