restoring a databse with change logs

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

  • Are you asking about restoring a chain of transaction log backups?

    "Got no time for the jibba jabba!"
    -B.A. Baracus

  • 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 ?

  • 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

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply