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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy