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 ««12

Disaster recovery Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 7:28 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 7, 2014 5:55 AM
Points: 608, Visits: 859
Thanks again, Gail.

I've enjoyed working with a new partner who has been helping me move from my old strategy to one based on the Ola Hollengren routines. He's confirmed that as it is implemented, the servers no longer use SIMPLE, but he leaves them in FULL. We knew that BULK_LOGGED was available.


Regards, Mike
Post #1453522
Posted Thursday, May 16, 2013 10:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 3:11 PM
Points: 8, Visits: 4
by using Tail log backup, we are restoring up to last sec also
Post #1453661
Posted Friday, May 17, 2013 4:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 15, 2013 1:39 PM
Points: 28, Visits: 58
aaroo,

Most suggestions are so far very helpful.

I'd like to share a different perspective from Paul Randal that we should focus on restore strategy first then come up with backup strategy.


Thanks.
Post #1454205
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse