Protecting SQL Servers
Traditionally, there have been several different methods for protecting SQL Server databases. The first method is to ensure that no transactions can occur by taking the database offline and then backing up the database files. The second method is to use SQL Server’s native backup tool, which relies on VSS and the SQL Server VSS writer to perform an online backup. The final method is to use a third-party backup tool, which might or might not employ VSS to perform a SQL Server backup.
In either case, most of the solutions that are designed to protect SQL Server databases all rely on single-point-in-time backups. However, like Exchange Server, SQL Server is a transaction-based application. Therefore, the data that is contained ...
Get Microsoft® System Center 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
