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

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

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:44 AM
Points: 3,017, Visits: 3,647
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 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,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