X hits on this document

497 views

0 shares

0 downloads

0 comments

121 / 200

Disaster recovery Disaster recovery of SQL Server databases

To rebuild the master database

1

Run the Rebuild Master utility (\SQL directory\bin\Rebuildm.exe).

Server

installation

Note: See the Microsoft SQL Server official documentation for information on how to use rebuildm.exe.

2

When the rebuild is complete, restart the SQL Server services if necessary.

To start SQL Server in single-user mode

Note: SQL agent will automatically put the database in single-user mode for restores of non-clustered SQL Server 2000 or higher.You need to start SQL Server in single-user mode only if SQL Server is configured in a cluster or if you have a version of SQL Server 7.0.

1

In the Windows Control Panel, open Services.

2

Select the MSSQLServer service

3

Type the following in the Startup Parameters box:

/m

4

Click Start.

To restore the SQL databases

1

If you have SQL 7.0, you must start SQL Server in single-user mode before restoring the SQL databases. See the previous procedure for details.

2 3

Open the NetBackup for SQL Client interface.

Locate all the media required to perform the restore operations. Choose File > Restore SQL Server objects.

4

Select the backup image that contains the copy of the master database to be restored.

121

Document info
Document views497
Page views497
Page last viewedThu Dec 08 02:12:49 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments