May 16, 2005 at 12:40 am
Hi
I have data file and transaction log file both on same disk array . I want to move transaction log file on different disk array ? How can I perform this task?
May 16, 2005 at 2:09 am
You can use detach/attach process to move it. First detach the database, then move the physical (log) file(s) to the new location and finally attach the database again. When the database is attached you should specify the new location of the log file(s) so that a new empty file is not created at the old location.
May 17, 2005 at 2:35 am
another thing to note here is that u can only do this when the "Recovery Mode" on the database is set to "full" ... otherwise, it just wont let u do it!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply