Backing up SQL Server is a standard practice, but knowing which recovery model to use can be confusing. Use these tips to get started with your backup strategy.

It is important to select the appropriate recovery model because doing so affects an organization’s ability to recover, manage, and maintain data.For enterprise production systems, the Full ...

Database is a VMware VM on a SAN, and the MDF is about 15GB. Recovery model is set to simple. I'm running SQL Server 2008R2 on Windows Server 2008R2.

SQL Server customers have other choices for the same capabilities – for example, Windows Server Failover Clustering — but Boxley says they are more expensive.