Backup of Standby DB (Transaction logs)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Backup of Standby DB (Transaction logs)

Backup of Standby DB (Transaction logs)

Rate Topic

Display Mode

Topic Options

Author

Message

saad_Ahmad1

Posted Tuesday, June 16, 2009 11:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 02, 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

ps.

Posted Tuesday, June 16, 2009 11:10 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620

see if this can be of some help!!
http://www.mssqltips.com/tip.asp?tip=1464

Pradeep Singh

Post #735867

Lynn Pettis

Posted Tuesday, June 16, 2009 11:11 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 21,633, Visits: 27,490

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.

Cool

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

saad_Ahmad1

Posted Tuesday, June 16, 2009 11:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 02, 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

saad_Ahmad1

Posted Tuesday, June 16, 2009 11:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 02, 2010 10:04 AM
Points: 6, Visits: 8

Tried it but no luck..any other ideas?

Post #735901

tosscrosby

Posted Tuesday, June 16, 2009 12:54 PM

SSCrazy

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 »

Permissions