August 4, 2009 at 3:31 pm
I have a database in simple RECOVERY MODE and want to move the transaction log to another drive. It gets huge due certain maintnenace routines but we don't care what's in the log. Due to how large it gets sometimes we want to move it to a different drive, BUT I don't want to take the time to copy a huge file that we don't care about. I would like to just have it open up a new file on the new drive. Is this possible and if so are there any "gotchas"?
August 4, 2009 at 8:06 pm
Yes you could - but you don't need to. Here is what I would do:
1) Shrink the current log file to an acceptable small size, say 100MB.
2) Detach the database
3) Copy the now smaller log file to the new drive
4) Attach the database and specify the new location for the log file
Done.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply