HP Software manual Apply changes to the master database, Drop invalid databases

Page 57

3.Run the restore job.

NOTE: This may take some time, typically 10 to 15 minutes, depending on the size of the master database. Restore only the master database while in single user mode. Do not restore any other databases.

If for some reason, your restore operation doesn’t work, rebuild the master database and attach all of your databases that reside in the data directory. To attach databases:

•In Enterprise Manager, right-click Databases and select Attach Database.

•In Query Analyzer, write and run a script that is similar to the following sample:

EXEC sp_attach_db @dbname = N'test_database', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\test_database.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\test_database.ldf'

Apply changes to the master database

1.Go to the SQL Server Manager and right-click the SQL server instance. Select Properties to open the SQL Server Properties window.

2.Under the General tab in the SQL Server Properties window, open the Startup Parameters window and remove “–m” from the list of existing parameters.

3.Restart the SQL server instance. (Right-click the SQL server instance and select Stop; right-click the SQL server instance and select Start.)

If there have been no changes to the master database since the last dump, proceed to Drop invalid databases (page 57)

.

4.If login IDs or devices have been added to or dropped from the master database since the last backup, those changes must be reapplied. Restart the server and reapply the changes manually or from saved batch files.

5.If databases have been created, expanded or shrunk since the last dump of master, those databases must be dropped and then restored.

Drop invalid databases

•Use the SQL Enterprise manager to drop any invalid database devices and databases from the newly restored master database.

NOTE: If you are recovering from a disaster where you have lost a database device file, the master database you have just restored still contains a reference to it. Data Protector Express will not be able to restore any databases contained on the database device until the file is restored or the database device is dropped. If the database device is dropped, Data Protector Express will automatically recreate the device when a database contained on the device is restored.

Working with Microsoft SQL Server 57

Page 56 Page 58
Image 57
Page 56 Page 58
Contents Data Protector Express User Guide Acknowledgments Contents Index Disaster RecoveryOverview ConceptsTerminology Overview Simple, Immediate Backup Restore to a Different Location Restore to a Different Location Administering Backup Using the AdministratorMain Window Missing Features Property PagesOpening Property Pages Viewing Data Protector Express status Using Quick Access from TaskbarManaging Data Protector Express Managing JobsMonitoring jobs SettingsManaging Alerts Managing LogsOther Commands About the Data Protector Express ServiceMicrosoft Windows and the Data Protector Express Server Linux and the Data Protector Express DaemonAbout the Data Protector Express Service Configuring Backup Jobs Selecting FilesSelecting Devices Configuration Schedule SettingsEncryption Backup mode Mode SettingsAuto verify mode Type of Fixed RotationSplit File Write modeAuto format mode Interval SettingsScheduled Dates Media to be usedAdvanced Options Advanced SettingsLog Options Settings for WindowsExecution Barcode FilterConfiguring Restore and Verify Jobs Selecting FilesSelecting Versions Restoring folders Restoring a file with a new nameRestoring files and folders to a different folder Advanced Restore Options Execution Options Advanced Verify OptionsBarcode Filter Options Working With Devices Selecting Devices for JobsDevice Properties Element status Device CommandsWorking With Devices Device Commands Working with Tape Libraries Installation and ConfigurationBarcodes and MIC memory in cartridge Barcode FiltersInitialization Process Media Management Sharing storage devices on a SANScheduling, Rotations, and Media Management Backup Schedule ConsiderationsScheduling Concepts Media SetsIntervals Implications for Restoring Data Media Rotation Types Comparing rotation types Running Jobs with RotationsEncryption and Compression EncryptionCryptographic Algorithms Encryption Options PassphraseCompression Key ManagementWorking with Third-Party Applications Configuring a Microsoft Exchange ServerMicrosoft Exchange Server Supported PlatformsBacking up Microsoft Exchange Server Restoring Microsoft Exchange Databases Disaster Recovery with Microsoft Exchange Server System-level Disaster RecoveryPreparing to Restore the Microsoft Exchange Server Mailbox Backup and Recovery Restoring the Microsoft Exchange MTA DatabaseRestoring Microsoft Exchange Databases Backing Up Mailboxes ConfigurationRestoring Mailboxes RequirementsWorking with Microsoft SQL Server PowerShell AccessSupported Exchange Server versions Mailbox PermissionsMicrosoft SQL server concepts Configuring the Microsoft SQL ServerBacking up Microsoft SQL Server Restoring Microsoft SQL Server Microsoft SQL Server Databases and the backup modeRestoring Microsoft SQL Server user databases Restoring Microsoft SQL Server 2000 master databases Restoring Microsoft SQL Server master databasesCreate Database Alter Database Stop the Data Protector Express and SQL Server servicesRestart SQL Server in single-user mode Restore the master database from the most recent backupRebuild the master database Drop invalid databases Apply changes to the master databaseStart the Data Protector Express and SQL Server services Restore the msdb databaseRestoring 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 Protecting Microsoft Windows SharePoint Services Windows SharePoint Services protection conceptsProtecting Windows SharePoint Services Restoring SharePoint Services Using Disaster Recovery with Windows SharePoint Services Working with Certificate ServicesDisaster Recovery Boot MediaImportant guidelines Advantage of Bootable Backup Devices Preparing For a DisasterRestoring to dissimilar hardware Create bootable media Configuring Backups to Support Disaster RecoveryTest the media Disaster Recovery with Libraries Recovering From a DisasterDisaster Recovery Disaster recovery for Windows 2003, Windows XP and earlier Disaster recovery for LinuxLimitations Completing the Data RestoreMail Settings Backup Domain ConfigurationPerformance Settings Alert SettingsSetting a User Password Client Upgrade SettingsDomain Security OptionsJob Log options Advanced Job OptionsLog Type Log file formatsPre Execution Commands Job Pre-Post Execution CommandsMail log AuditingPost Execution Commands Barcode Filters for JobsLogs Advanced Job Options Contacting HP Support and other resourcesRelated information Typographic conventionsDocumentation feedback Index Index VSS
Related manuals
Manual 1 pages 61.46 Kb Manual 1 pages 6.39 Kb
Top Page Image Contents