restoring change logs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » restoring change logs

restoring change logs

Rate Topic

Display Mode

Topic Options

Author

Message

chilidogie

Posted Friday, February 06, 2009 8:21 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:41 AM
Points: 27, Visits: 76

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 !!

Post #651719

tosscrosby

Posted Friday, February 06, 2009 12:48 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316

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.

Post #651938

« Prev Topic | Next Topic »

Permissions