SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


restoring a databse with change logs


restoring a databse with change logs

Author
Message
chilidogie
chilidogie
SSC Veteran
SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)

Group: General Forum Members
Points: 213 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 !!
the__t
the__t
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1546 Visits: 419
Are you asking about restoring a chain of transaction log backups?

"Got no time for the jibba jabba!"
-B.A. Baracus
chilidogie
chilidogie
SSC Veteran
SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)

Group: General Forum Members
Points: 213 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 ?
the__t
the__t
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1546 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
chilidogie
chilidogie
SSC Veteran
SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)

Group: General Forum Members
Points: 213 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 !
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search