Data Protection for SQL Server

Heard of Data Protection Manager?

DPM 2007 is a member of the Microsoft System Center family of management products, which are designed to help IT Professionals manage their Windows Server® infrastructure. First announced in September 2006, and now out as Beta 2, DPM 2007 sets a new standard for Windows® backup and recovery—delivering continuous data protection for Microsoft application and file servers to a seamlessly integrated secondary disk and tape solution on the DPM server. DPM enables rapid and reliable recovery through advanced technology for enterprises of all sizes.

DPM 2007 uses a combination of transaction log replication and block-level synchronization in conjunction with the SQL 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.

https://www.microsoft.com/systemcenter/dpm/default.mspx

Technorati Tags: Data Protection Manager, SQL Server 2005, SQL Server 2000