Change Log File location

[AnnTiSpam]

I have a customer who has the transaction logs on the same partition as the database. I created a new partition for them on the mirrored drives and want to move the transactions logs onto it. How do you move the log files over to the new partitions? I can't find any reference to that on the Technet website.

 

[esdee]

alter database wont help ?

 

[tlbroadbent]

Detach the databse. Move the LDF file to the dsired location. Attach the database. See "Attaching and Detaching a Database" in SQL BOL.

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_03_89pv.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[jester777]

I find moving database files and transaction logs much easier to do by dumping and restoring.
The restore database command has a WITH MOVE option where you can change the location of the database & tran log files.
EG I've got a db called test-1, I want to move the tran log whose logical filename is test-1_Log to a new drive I can do the following


restore database [test-1] from disk = 'c:\test-1.bak' with move 'test-1_Log' to 'c:\test-1_newlog.LDF'

 

[tlbroadbent]

While I agree that Dump and Restore may be simpler, it can take much longer causing more down time than the Detach, Move, Attach method. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.