Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, December 5, 2016 5:56 AM
Points: 777, Visits: 1,063
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.


Mike Hinds
Senior Database Administrator
1st Source Bank
MCP, MCTS
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: Wednesday, October 7, 2015 5:18 PM
Points: 28, Visits: 67
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