August 20, 2004 at 3:47 pm
Up to now, all of our SQL Servers have used SIMPLE recovery because that is all our business required. I am now setting up some databases with full recovery and I have a question about restoring the transaction log.
When you restore the log but you are putting the database in a different place, do you use the WITH MOVE option on the log restore? If so, do you do a WITH MOVE on both the data file and the log file?
I did a RESTORE FILELISTONLY on the log backup and I got the two file names for the database but I am not sure how to use them in this case. I use the WITH MOVE option all the time on database restores.
Thanks.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 20, 2004 at 4:26 pm
Using the with move is only in restoring the database. You wouldn't use this with the log.
when restoring the log, the database must have been restored with the "norecovery" or "standby" options.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply