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

Backup of Standby DB (Transaction logs) Expand / Collapse
Author
Message
Posted Tuesday, June 16, 2009 11:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 2, 2010 10:04 AM
Points: 6, Visits: 8
I have restored a DB backup image sent to us from our client in Standby mode.
After I have restored the DB backup image in Standby mode, I restore daily transaction logs that are shipped to me.

Every month I would like to a backup of this Database so that if something fails, I only have to restore the backup taken at the end of the month rather then catching up on 4-5 months of T-logs.

What I tried to do is as follows:

-Restore the DB backup image (sent by client) in Standby Mode for Jan 1/09.

-Apply T-logs (sent by client) to this Standby Database up until Jan 30/09

-For the Jan 31 T-log, I applied this against the DB but the option I selected to apply this T-log was in Restore Recovery mode

-Purpose was to be able to take a backup image.

-After I took the backup image, I restored the backup image into Standby Mode so that it can accept the Feb 1/09 T-log

-When I tried to apply the T-log I got the error

'This backup set cannot be applied because it is on a recovery path that is inconsistent with the database'

Why is that? Anyone have a workaround?
Post #735859
Posted Tuesday, June 16, 2009 11:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 1, 2014 1:26 PM
Points: 2,242, Visits: 3,645
see if this can be of some help!!
http://www.mssqltips.com/tip.asp?tip=1464





Pradeep Singh
Post #735867
Posted Tuesday, June 16, 2009 11:11 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 23,289, Visits: 32,016
By doing that, you have broken the log chain from the source database (client). About the only way I can see around this would be do shut SQL Server down and then make a copy of the mdf/ldf files. Not sure if this will work, but it is worth a try.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #735868
Posted Tuesday, June 16, 2009 11:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 2, 2010 10:04 AM
Points: 6, Visits: 8
If I make a copy of the .mdf and .ldf of the StandBy Database and then drop the Standby Databse, how do I restore it?
Post #735891
Posted Tuesday, June 16, 2009 11:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 2, 2010 10:04 AM
Points: 6, Visits: 8
Tried it but no luck..any other ideas?
Post #735901
Posted Tuesday, June 16, 2009 12:54 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316
If you have the .mdf and .ldf you can simply attach the database, no restore involved. If it's truly a .bak, then it's restore database.

-- You can't be late until you show up.
Post #735952
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse