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: Saturday, October 22, 2016 9:41 AM
Points: 3,039, Visits: 3,721
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. 29 Aug 2016: now over 38,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Post #1439764
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse