<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Perry Whittle
»
Repairing a Broken Log Shipping Plan From a...
12 posts, Page 1 of 2
1
2
»»
Repairing a Broken Log Shipping Plan From a Differential Backup
Rate Topic
Display Mode
Topic Options
Author
Message
Perry Whittle
Perry Whittle
Posted Wednesday, September 26, 2012 10:35 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:32 AM
Points: 5,204,
Visits: 11,159
Comments posted to this topic are about the item
Repairing a Broken Log Shipping Plan From a Differential Backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1365028
joeroshan
joeroshan
Posted Thursday, September 27, 2012 2:12 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 573,
Visits: 1,169
Great article. Very useful for DBA in production environment.
-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1365086
Perry Whittle
Perry Whittle
Posted Thursday, September 27, 2012 2:27 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:32 AM
Points: 5,204,
Visits: 11,159
joeroshan (9/27/2012)
Great article. Very useful for DBA in production environment.
Hi, thanks for the feedback, please don't forget to rate the article if you found it useful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1365090
karen_jonesdba
karen_jonesdba
Posted Thursday, September 27, 2012 11:45 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:24 PM
Points: 11,
Visits: 144
Could this be used for a site to site DR test where the standby database is opened with recovery for the users to test and then log shipping is rebuilt from scratch by taking a backup of the primary and reinitializing the standby? Could we instead stop the log shipping jobs (bkp,copy,restore), open the standby for the users to test, take a differntial backup of the primary and use that to restore the standby, then restart the log shipping jobs.
Post #1365419
kavitha0416
kavitha0416
Posted Thursday, September 27, 2012 1:16 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, February 22, 2013 1:06 PM
Points: 3,
Visits: 85
database has once a day full backup and hourly log backup. No diff. log shipping is for every one hour. Secondary fails at restore due to out of sync lsn.
Post #1365473
mohammed moinudheen
mohammed moinudheen
Posted Thursday, September 27, 2012 7:41 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:28 AM
Points: 2,170,
Visits: 3,583
Very good one Perry.
Rated it 5 star :)
Mohammed Moinudheen
Post #1365576
Perry Whittle
Perry Whittle
Posted Thursday, September 27, 2012 11:42 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:32 AM
Points: 5,204,
Visits: 11,159
mohammed moinudheen (9/27/2012)
Very good one Perry.
Rated it 5 star :)
Hey thanks Mohammed, appreciate the feedback
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1365618
Perry Whittle
Perry Whittle
Posted Friday, September 28, 2012 1:53 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:32 AM
Points: 5,204,
Visits: 11,159
karen_jonesdba (9/27/2012)
Could this be used for a site to site DR test
Not really, no.
karen_jonesdba (9/27/2012)
Could we instead stop the log shipping jobs (bkp,copy,restore), open the standby for the users to test, take a differntial backup of the primary and use that to restore the standby, then restart the log shipping jobs.
No, the process above has the wrong ordering. You would need to follow along the lines of
stop all Log shipping jobs (backup, copy, restore and alert)
run the copy job and then the restore job to ensure that any remaining log backups are restored to the secondary.
take a tail log backup on the primary, this will leave the primary database in the restoring state
restore tail log backup to the secondary with recovery bringing the database online
Perform the same again on the new primary to switch back to the original primary and then re enable the Log Shipping jobs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1365660
karen_jonesdba
karen_jonesdba
Posted Friday, September 28, 2012 5:18 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:24 PM
Points: 11,
Visits: 144
Ok.. unfortunately we do not failback to the primary with data. The primary is left usable and running during the DR test and the standby is opened just for the duration of test then resyncronized with a full backup and new log shipping jobs. that is the policy.
Steps are we drop logshipping, open the standby, and at the end of the test resync the standby and resetup logshipping. I was hoping that if we stopped the jobs on the primary(instead of dropping) that after the test was done I could take a differential backup, resync the standby with this backup and let then let the log shipping jobs run. This is a big database and takes a long time recyncing from a full.. Thanks for getting back!
Post #1365783
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
Posted Friday, September 28, 2012 3:42 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 3,051,
Visits: 1,358
Very nice article Perry! Thanks for sharing!
My blog
Post #1366126
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
