HP Software manual Restart Microsoft SQL Server in single-user mode

Page 60

8.If not correctly displayed in the SQL Server Installation Path window, enter the location of the existing SQL Server installation and click Continue.

The Rebuild Master Database window appears.

9.If it is not correctly displayed in the Rebuild Master Database window, enter the location and name of the existing MASTER device. Also enter a MASTER device size and click Continue.

The setup program will then rebuild the master database.

10.When rebuilding is complete and the completion window appears, click Exit.

NOTE: The files MASTER.DA@ and MASTER.AL@ are stored in the \MSSQL\INSTALL directory. When rebuilding the master database (or when installing SQL Server), one of these two files is used by the setup program. When the default sort order and character set are selected, MASTER.DA@ is expanded and copied onto the server, replacing MASTER.DAT. When an alternate character set and/or sort order is selected, MASTER.AL@ is expanded, copied onto the server, and several SQL scripts are run.

Restart Microsoft SQL Server in single-user mode

Before you can restore the master database, you must start Microsoft SQL Server in single-user mode.

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 type “–m” in the Parameter field.

3.Click the Add command, and then click OK. Close the SQL Server Properties window by clicking OK.

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

NOTE: You may find it convenient to start the SQL Server in single-user mode using the command line program, SQLSERVER.EXE, with option “/m”. This procedure will only work, however, if the SQL Server is configured to start using the current interactive user’s account.

Restore the master database from the most recent backup

1.Create a restore job and select the most recent backup version of the master database.

2.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.

Apply changes to the master database

1.Go to the SQL Server Enterprise Manger 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, then proceed to Drop invalid databases and database devices (page 61).

60 Working with Third-Party Applications

Page 59 Page 61
Image 60
Page 59 Page 61
Contents Data Protector Express User Guide Acknowledgments Contents Disaster Recovery IndexOverview 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 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 Configuring Backup Jobs Selecting FilesSelecting Devices Configuration Schedule SettingsEncryption 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 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 Advanced Verify Options Execution OptionsBarcode Filter Options Working With Devices Selecting Devices for JobsDevice Properties Device Commands Element statusWorking With Devices Device Commands Installation and Configuration Working with Tape LibrariesBarcodes and MIC memory in cartridge Barcode FiltersInitialization Process Sharing storage devices on a SAN Media ManagementBackup Schedule Considerations Scheduling, Rotations, and Media ManagementScheduling Concepts Media SetsIntervals Implications for Restoring Data Media Rotation Types Running Jobs with Rotations Comparing rotation typesEncryption and Compression EncryptionCryptographic 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 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 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 DatabaseRestart SQL Server in single-user mode Restore the master database from the most recent backupRebuild the master database Apply changes to the master database Drop invalid databasesStart 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 Working with Certificate Services Using Disaster Recovery with Windows SharePoint ServicesDisaster Recovery Boot MediaImportant guidelines Advantage of Bootable Backup Devices Preparing For a DisasterRestoring 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 AuditingPost Execution Commands Barcode Filters for JobsLogs 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
Top Page Image Contents