|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:47 AM
Points: 778,
Visits: 1,047
|
|
I have mirrored databases at an off-site location and perform daily full back-ups burnt to disc how safe is my plan.What do you recommend?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730,
Visits: 29,996
|
|
Have you tested it? If not, that plan is not worth the paper it's printed on. If so, could you mean the downtime and data loss SLAs you have in place?
Gail Shaw Microsoft Certified Master: SQL Server 2008, MVP SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter We stand on the bridge and no one may pass
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:47 AM
Points: 778,
Visits: 1,047
|
|
Plan tested successfully.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730,
Visits: 29,996
|
|
If you tested the plan and managed to make all the SLAs involved, then it works. If you couldn't, it needs revising. That's what it comes down to in the end.
Gail Shaw Microsoft Certified Master: SQL Server 2008, MVP SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter We stand on the bridge and no one may pass
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:47 AM
Points: 778,
Visits: 1,047
|
|
Ok,thank you.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
|
|
|
|