April 25, 2003 at 9:23 am
Is there a way to MOVE the transaction log of a database to a different drive on my server? The database is already running and operational. I am looking to see if there is a script that will allow me to move the transaction log. Any suggestions will be helpful.
Thank you
April 25, 2003 at 10:00 am
Detach the database, move the transaction log file to new drive and attach database back. See BOL sp_detach_db and sp_attach_db for details.
April 25, 2003 at 10:18 am
You can also move on a backup and restore, but I would follow Allen's advice if you just want to move an existing db.
Steve Jones
April 25, 2003 at 12:58 pm
I tried but never could find a way to do it by just manipulating the system tables. Detach/attach is fastest, won't work if replicated.
Andy
April 25, 2003 at 3:43 pm
Correct me if i am wrong. To do attach dettach the database should not be operational i mean should not be used.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply