Changing location of the Transaction Log 1

[cricketer1]

I have a transaction log that is currently in a drive that is becoming full. I need to relocate this transaction log to another drive to where it's data file is. This is a production database and supports a website. What are my options. How would I do this.

Thanks

 

[redlam]

if you have to keep the site 'live' while you do this, you could just add the new location to the existing transaction log file. sql will automatically use the new space as needed or you can limit the size of the original file so that it uses it immediately. to do this, just right click on the database in em and select 'properties' and go to the transaction log tab.

 

[dbmsguy]

to move the transaction log, or for that matter the database, you can.

1. exec sp_detach_db (look it up, but you can specify exactly what file).
2. move the file to the new drive.
3. exec sp_attach_db (specify the new location)

you have now moved the entire transaction log. Paul

http://www.dbmsguy.com

 

[dbmsguy]

sorry, you would have to detach the entire db and then reattach the db specifying the new location for the tran log...... Paul

http://www.dbmsguy.com