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 www.ColbyConsulting.com 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/ >