[dba-SQLServer] SQL Server 2005 unresponsive

jwcolby jwcolby at colbyconsulting.com
Fri Sep 4 19:25:50 CDT 2009

I found a way to move the temp db files, which I moved to a raid 0 drive by itself.

The log files are another matter.  Obviously each db has one and AFAICT they have to be moved db by 
db.  I will move the log files for the major databases.  It would be nice if there was a way to just 
say "put all log files here".

John W. Colby

Stuart McLachlan wrote:
> Open Management Studio
> To change the defaults:
> Right click on the Server and select Properties.
> Go to the "Database Settings" tab and you can define the locations for the data and log files.
> To change the location of data and log files for any normal database. 
> Detach the database
> Move the data and log files to anywhere you want then
> Attach the database and point to the new locations for the files.
> To change the location of tempdb:
> http://www.tech-recipes.com/rx/2342/sql_server_2005_move_tempdb/

More information about the dba-SQLServer mailing list