HP Software Restoring Microsoft SQL Server, Microsoft SQL Server Databases and the backup mode

Page 52

NOTE: Anytime Data Protector Express returns an error message that is greater than 10000, a Microsoft SQL or Exchange error has occurred. Refer to your Microsoft documentation for more information as this is a Microsoft error code.

Microsoft SQL Server Databases and the backup mode

The Backup mode on the Options tab of a job that backs up SQL Server database instances is especially critical.

Backup modes

When the Full setting is selected, all files selected for backup are backed up, including SQL Server database instances and databases. However, when either the Incremental or Differential option is selected, Data Protector Express backs up only the transaction logs for each database.

CAUTION: There is no difference between Incremental and Differential jobs for SQL Server databases.

When the Backup mode is set to Copy, Data Protector Express a creates a full backup of the database but does not truncate the logs.

Additional Conditions

Master, Model, MSDB and Pubs databases support only full backups. The Backup mode option is automatically set to Full when backing up these databases.

If you set a job to run in either Incremental or Differential mode and the job can only run as a full backup (as a result of the provision above), the job will fail to run on each of its initial passes, but will run in Full backup mode on its final pass.

Using Data Protector Express with SQL Server’s Backup Routine

Microsoft SQL Server has default utilities and commands for backing up data. When you use Data Protector Express to back up SQL Server databases, you can still use these default SQL Server utilities and commands.

For example, you can use the DUMP command to dump transaction logs to the dump device (preferably, a separate disk drive). You can set this up to occur at regular intervals, such as every 15 minutes or every hour. Next, you can create a backup job that backs up these transaction logs onto archival media every day.

In general, when you implement Data Protector Express to back up your SQL Server databases, continue to use SQL Server’s internal commands to duplicate and back up transaction logs. Set up a separate Data Protector Express backup job to write these duplicated transaction logs to archival media.

Restoring Microsoft SQL Server

When restoring SQL Server databases, you must:

1.Restore a full backup of the SQL Server database.

2.Restore the logs in the order created.

3.Follow special procedures when renaming databases (if you rename databases).

NOTE: Any time Data Protector Express returns an error message that is greater than 10000, a Microsoft SQL or Exchange error has occurred. Refer to your Microsoft documentation for more information as this is a Microsoft error code.

Restoring Microsoft SQL Server databases and transaction logs

When recreating a database, you must first restore the whole database (created by a backup job running in full backup mode).

52 Working with Third-Party Applications

Image 52
Contents Data Protector Express User Guide Acknowledgments Contents Disaster Recovery IndexConcepts OverviewTerminology Overview Simple, Immediate Backup Restore to a Different Location Restore to a Different Location Using the Administrator Administering BackupMain Window Property Pages Missing FeaturesOpening Property Pages Using Quick Access from Taskbar Viewing Data Protector Express statusManaging Data Protector Express Managing JobsSettings Monitoring jobsManaging Alerts Managing LogsAbout the Data Protector Express Service Other CommandsMicrosoft Windows and the Data Protector Express Server Linux and the Data Protector Express DaemonAbout the Data Protector Express Service Selecting Files Configuring Backup JobsSelecting Devices Schedule Settings ConfigurationEncryption Mode Settings Backup modeAuto verify mode Type of Fixed RotationWrite mode Split FileInterval Settings Auto format modeScheduled Dates Media to be usedAdvanced Settings Advanced OptionsSettings for Windows Log OptionsExecution Barcode FilterSelecting Files Configuring Restore and Verify JobsSelecting Versions Restoring a file with a new name Restoring foldersRestoring files and folders to a different folder Advanced Restore Options Advanced Verify Options Execution OptionsBarcode Filter Options Selecting Devices for Jobs Working With DevicesDevice Properties Device Commands Element statusWorking With Devices Device Commands Installation and Configuration Working with Tape LibrariesBarcode Filters Barcodes and MIC memory in cartridgeInitialization Process Sharing storage devices on a SAN Media ManagementBackup Schedule Considerations Scheduling, Rotations, and Media ManagementMedia Sets Scheduling ConceptsIntervals Implications for Restoring Data Media Rotation Types Running Jobs with Rotations Comparing rotation typesEncryption Encryption and CompressionCryptographic Algorithms Passphrase Encryption OptionsKey Management CompressionConfiguring a Microsoft Exchange Server Working with Third-Party ApplicationsMicrosoft Exchange Server Supported PlatformsBacking up Microsoft Exchange Server Restoring Microsoft Exchange Databases System-level Disaster Recovery Disaster Recovery with Microsoft Exchange ServerPreparing to Restore the Microsoft Exchange Server Restoring the Microsoft Exchange MTA Database Mailbox Backup and RecoveryRestoring Microsoft Exchange Databases Configuration Backing Up MailboxesRestoring Mailboxes RequirementsPowerShell Access Working with Microsoft SQL ServerSupported Exchange Server versions Mailbox PermissionsConfiguring the Microsoft SQL Server Microsoft SQL server conceptsBacking up Microsoft SQL Server Microsoft SQL Server Databases and the backup mode Restoring Microsoft SQL ServerRestoring Microsoft SQL Server user databases Restoring Microsoft SQL Server master databases Restoring Microsoft SQL Server 2000 master databasesStop the Data Protector Express and SQL Server services Create Database Alter DatabaseRestore the master database from the most recent backup Restart SQL Server in single-user modeRebuild the master database Apply changes to the master database Drop invalid databasesRestore the msdb database Start the Data Protector Express and SQL Server servicesRestoring Microsoft SQL Server 7 master databases Disk Mirror Disk Unmirror Disk Remirror Restart Microsoft SQL Server in single-user mode Drop invalid databases and database devices Windows SharePoint Services protection concepts Protecting Microsoft Windows SharePoint ServicesProtecting Windows SharePoint Services Restoring SharePoint Services Working with Certificate Services Using Disaster Recovery with Windows SharePoint ServicesBoot Media Disaster RecoveryImportant guidelines Preparing For a Disaster Advantage of Bootable Backup DevicesRestoring to dissimilar hardware Configuring Backups to Support Disaster Recovery Create bootable mediaTest the media Recovering From a Disaster Disaster Recovery with LibrariesDisaster Recovery Disaster recovery for Linux Disaster recovery for Windows 2003, Windows XP and earlierCompleting the Data Restore LimitationsBackup Domain Configuration Mail SettingsPerformance Settings Alert SettingsClient Upgrade Settings Setting a User PasswordDomain Security OptionsAdvanced Job Options Job Log optionsLog Type Log file formatsJob Pre-Post Execution Commands Pre Execution CommandsMail log AuditingBarcode Filters for Jobs Post Execution CommandsLogs Advanced Job Options Support and other resources Contacting HPRelated information Typographic conventionsDocumentation feedback Index Index VSS
Related manuals
Manual 1 pages 61.46 Kb Manual 1 pages 6.39 Kb