【正文】 anging files. However, the most critical business applications tend to use transactional databases like Microsoft SQL Server or Microsoft Exchange Server. Backing up and restoring data from these databases is significantly more difficult than backing up static files. Many existing realtime replication or continuous data protection products offer file or volumelevel replication that blindly replicates changes to the underlying disk without awareness of what the applications are actually doing. Microsoft and most other major software vendors provide supported interfaces in their applications for capturing data。 if a recovery is required, the most recent DPM differential backup can be bined with the most recent set of transaction logs to provide rapid recovery to the desired RPO. Once the administrator chooses which pointintime recovery point to use for the restore, DPM assembles the necessary data from logs, differential backups, and full backups. This assembly process is pletely automatic and doesn’t require the administrator to be an expert in SQL Server database recovery. Similar protective methods are used to protect Exchange Server and SharePoint Server puters. Because DPM is aware of specific applications, it can tailor its backup behavior and methods to the requirements and usage patterns of specific applications.Seamless Disk and TapeBased RecoveryDPM allows you to bine the best aspects of diskbased and tapebased backup systems. Diskbased backups extremely fast recovery and more flexibility around continuous protection. Tapebased backups are slower, but have lower media acquisition costs. Because you can choose which backups are stored where, you can control how many backup generations you keep on disk versus how many are stored on tape to find the best balance between recovery time, backup depth, and storage utilization. Because DPM provides a seamless view of both disk and tapebased recovery points, you can easily select the exact data items to restore no matter where they’re located. By using DPM you can bine the ability to quickly recover a shortterm snapshot from disk with the ability to go as far back in time as your tape collection permits and recover any arbitrary data that you need. (See Figure Figure 1: Easy recovery from disk or tape – by date and timeEase of Use and ManagementDPM makes the power of its bined disk and tapebased backup capabilities available using a familiar, approachable interface. Data Protection Manager is part of System Center, Microsoft’s family of management products that build Microsoft’s productspecific expertise and rich IT knowledge into management tools. DPM provides structured workflows and wizards that walk IT generalists and SQL administrators through a series of straightforward steps: browsing the available SQL servers, instances, and databases, setting recovery goals and retention requirements, and performing restores. DPM handles locating the data, managing the diskbased images and logs, specifying a tape rotation policy, and all the other minutiae of backup and recovery management. As part of the System Center family, DPM also offers full support for the PowerShell scripting environment, meaning that administrators can easily perform mon tasks from the wizardbased DPM interface or from the mand line. PowerShell can be used to create scripts that automate frequent operations or to build custom workflows for lessskilled administrators.DPM works easily with other Microsoft products, including System Center Operations Manager, to give you full visibility into the health and status of the servers you’re protecting and the DPM server that is helping you protect them, as well as System Center Configuration Manager to automatically deploy DPM protection agents on to production servers. Using Microsoft DPM to Protect Microsoft SQL Server When used with Microsoft SQL Server, Microsoft System Center Data Protection Manager (DPM) provides data protection and the ability to recover data at the database level. While DPM can provide filelevel recovery for data on protected file servers, the various data structures within a database are usually much more interdependent than file data. The DPM protection agent on a puter running SQL Server takes advantage of the VSS capabilities of Windows Server 2003 to take a snapshot of the entire database at once, ensuring that there is always a consistent view of the data. This prevents the possibility of data corruption caused by recovering tables or even specific rows within a table independently of related data needed to properly reconstruct the database.DPM provides protection for databases on the following versions and editions of Microsoft SQL Server:? SQL Server 2000 (any edition), with Service Pack 4 installed. Shared disk cluster configurations are supported, as long as all resources are associated with the same network name.? SQL Server 2005 any edition, with Service Pack 1 installed. Shared disk cluster configurations are supported, as long as all resources are associated with the same network name. Mirrored database servers and SQL Servers performing log shipping are also well supported with DPM.When a protected cluster node experiences an unplanned failover, DPM will alert the administrator to perform a consistency check of the protected data.Deploying DPM to Protect SQL ServersWhen you are ready to introduce DPM into your production environment, the first major task you need to perform is to install the DPM server. This involves installing and configuring DPM. You can find detailed guidance on this process in Chapter 1, “Installing DPM,” of the Microsoft System Center Data Protection Manager 2007 Deployment Guide. Before you begin the deployment process, verify that your deployment meets the hardware and configuration requirements outlined in the Deployment Guide.This section provides instructions for using DPM160