Does your company rely on Microsoft SQL Server to manage and deliver information? Are you deploying or migrating to SQL 2008? Who will you trust to maximize its protection and recovery?
Are you deploying or migrating to Microsoft SQL Server 2008? Microsoft System Center Data Protection Manager (DPM) 2007 is designed for the Database Administrator or the IT generalist and uses wizards and workflows to help ensure that you can protect your data—without requiring an advanced degree, training, or certification in storage and backup technologies.
DPM 2007 protects SQL Server databases every 15 minutes, but can restore not only to each of those 15-minute marks, but also enable administrators to recovery to any transaction point, or even to the very latest committed transaction following an outage.
As discussed in the April 23rd “What’s next for DPM 2007” webcast, a rollup update is planned around May 2008, which offers supported protection of Windows Server 2008 and SQL Server 2008. SQL Server 2008 has been reliably protected with DPM 2007 since the SQL Server “Katmai” July 2007 customer preview #4, but supported protection will begin upon SQL Server 2008 release to manufacturing (RTM).
How does DPM 2007 protect SQL Server?
DPM 2007 uses a combination of transaction log replication and block-level synchronization in conjunction with the SQL Server VSS Writer to help ensure your ability to recover SQL Server databases. After the initial baseline copy of data, two parallel processes enable continuous data protection with integrity:
Transaction logs are continuously synchronized to the DPM 2007 server, as often as every 15 minutes.
An “express full” uses the SQL Server VSS Writer to identify which blocks have changed in the entire production database, and sends just the updated blocks or fragments. This provides a complete and consistent image of the data files on the DPM server or appliance. DPM 2007 maintains up to 512 shadow copies of the full SQL Server database(s) by storing only the differences between any two images.
How does DPM 2007 protect SQL Server?
DPM 2007 uses a combination of transaction log replication and block-level synchronization in conjunction with the SQL Server VSS Writer to help ensure your ability to recover SQL Server databases. After the initial baseline copy of data, two parallel processes enable continuous data protection with integrity:
Transaction logs are continuously synchronized to the DPM 2007 server, as often as every 15 minutes.
An “express full” uses the SQL Server VSS Writer to identify which blocks have changed in the entire production database, and send just the updated blocks or fragments. This provides a complete and consistent image of the data files on the DPM server or appliance. DPM 2007 maintains up to 512 shadow copies of the full SQL Server database(s) by storing only the differences between any two images.
