Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

restoring a databse with change logs Expand / Collapse
Author
Message
Posted Friday, February 06, 2009 9:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:41 AM
Points: 27, Visits: 76
Greetings again !! (this was originally under forum heading SQL 2007....wrong place !!)

I am trying to make sure that when we restore from backup, the change 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 OUR_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 #651762
Posted Friday, February 06, 2009 9:37 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 30, 2010 9:49 AM
Points: 268, Visits: 419
Are you asking about restoring a chain of transaction log backups?


"Got no time for the jibba jabba!"
-B.A. Baracus
Post #651800
Posted Friday, February 06, 2009 9:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:41 AM
Points: 27, Visits: 76
Our system backs up the data into the "bu" file. When the data is restored thru the menu system, the change logs are restored. However, the latest build of the system messed up the backup restore so we need to do it manually. Everything is is the "bu" file. however, only the database "OUR_data" is being restored thru SQL. Is there anyway of looking at the backup file/databse to see if the change log files are there ?
Post #651805
Posted Friday, February 06, 2009 9:48 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 30, 2010 9:49 AM
Points: 268, Visits: 419
I may be leading in the wrong direction because I'm not understanding the "system" you are talking about, but if the "bu" file is like any other sql backupset, then restore filelistonly is what you are looking for to determine the contents of the backupset.


"Got no time for the jibba jabba!"
-B.A. Baracus
Post #651813
Posted Friday, February 06, 2009 1:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:41 AM
Points: 27, Visits: 76
Our system is a small database system written in VB and SQL, keeping all the data in SQL. It has a backup utility that backs up to the files mentioned. The 'restore filelistonly' works very well...thank you for the tip. I have most of my background in VB, VFoxpro and MUMPS. Little by little with SQL. The change logs for most of the work done last year disappeared with the last system-invoked restore. Although they don't show in the filelistonly query, I am sure I can get the chain linked back into the database somehow.

Thanx again !
Post #651967
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse