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

*MAY* need to switch DBs from Full Recovery to Simple, due to backup space issues... Expand / Collapse
Author
Message
Posted Monday, April 8, 2013 5:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 2,867, Visits: 3,204
What are your SLAs for RTO and RPO? If you do not have SLAs for these items you are most likely either using more money than your business wants you to, or you are risking business continuity by not being able to recover essential data.

Dealing with lack of disk space for backups may be this morning's problem, but you really need to deal with aligning your SLAs with what can be delivered.

If your business is happy to have 12 hours data loss on SharePoint, then there is no need for these databases to ever have been in Full recovery mode.

If your business reckons it will cost $1m for every minute of data lost in a recovery, then you need to tell your boss he is currently exposed for $720m of costs until he can get you $20k more disk space. It should get their attention.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1439764
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse