February 6, 2009 at 8:21 am
Greetings again !!
I am trying to make sure that when we restore from backup, the channge logs get restored also. The query given to me by the help desk does not include all the change logs....only the current one (generally empty). I am using the following query. Can anyone point me in the right direction to get all the change logs (I believe the file names are "OUR_CHANGE_LOG_0000/0001/0002....)
---------------------------------------------------------------------
restore database CW_Data from disk = 'C:\1_12_09\bu_1_12_09.cwb'
with move 'OUR_Data' to 'C:\Program Files\Microsoft SQLServer\MSSQL$test\Data\OUR_Data.MDF',
move 'OUR_Log' to 'C:\Program Files\Microsoft SQLServer\MSSQL$test\Data\OUR_Data_Log.mdf',
Replace
---------------------------------------------------------------------
Thanx !!
February 6, 2009 at 12:48 pm
Duplicate post. Post all replies to the link below. OP - Please don't double post as it will waste people's time when they respond to one and you've received the answer on the other....
http://www.sqlservercentral.com/Forums/Topic651714-8-1.aspx
-- You can't be late until you show up.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply