Logshipping Query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Logshipping Query

Logshipping Query

Rate Topic

Display Mode

Topic Options

Author

Message

mahesh.dasoni

Posted Friday, January 11, 2013 1:10 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:25 AM
Points: 81, Visits: 864

Logshipping is out of sync for 2 days and so i have a huge amount of logfiles to copy and restore to DR Server.Is there any way by which i can reduce my time of restoring all these logfiles and instead do something by which my logshipping can start without restoring all the logfiles one by one.

Post #1405795

anthony.green

Posted Friday, January 11, 2013 1:24 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

How often do you do FULL backups?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1405805

Bhuvnesh

Posted Friday, January 11, 2013 1:28 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

mahesh.dasoni (1/11/2013)

i can smell that its again interview question ? anyways restore latest backup would be easier and appropriate approach here

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1405810

opc.three

Posted Friday, January 11, 2013 6:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:07 PM
Points: 6,826, Visits: 11,951

If you have not taken a full backup on the primary since log shipping became out-of-sync then you can bring the secondary up to date and resuming the existing log shipping configuration by taking a differential backup from the primary and restoring it on the secondary. If you have taken a full backup from the primary since log shipping went out-of-sync then you will need to re-initialize log shipping from a full backup.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1405979

Ignacio A. Salom Rangel

Posted Sunday, January 20, 2013 2:45 PM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:05 PM
Points: 3,051, Visits: 1,364

Opc is right about the differential backup. About restoring the full backup. If the size of the DB is big and if you have all transaction logs I will probably copy all the transaction logs and start the restore job. If restoring the differential is an option I'll will chose that one for sure.

My blog

Post #1409310

« Prev Topic | Next Topic »

Permissions