X hits on this document

479 views

0 shares

0 downloads

0 comments

171 / 200

Chapter

10

Using NetBackup for SQL Server with database mirroring

Database mirroring is a software solution introduced in SQL Server 2005, service pack 1, to increase the availability of a SQL Server database. It uses two database instances (normally on different hosts), which contain copies of the same SQL Server database. These databases are identical in both name and content. The copies are the principal and the mirror. The mirror serves as a hot standby to the principal, where transactions take place. The mirror is very closely synchronized with the principal through transaction log porting. It is immediately available in case the principal fails.

The primary consideration when you establish your backup and restore procedures for database mirroring is that these operations are only available on the principal database.

For a complete description of database mirroring see the SQL Server 2005 Books online.

Configuring NetBackup to support database mirroring

To use database mirroring with NetBackup, both the principal and the mirror should be set up as clients of the same master server.

To configure NetBackup to support database mirroring

1

The hosts containing both databases should specify the same master server in their server lists.

Document info
Document views479
Page views479
Page last viewedTue Dec 06 22:06:20 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments