Database Reference
In-Depth Information
Getting ready
For the prerequisites to install database mirroring, please refer to the
Implementing
database
mirroring
features
and
performance
enhancements
recipe. In order to configure the log
shipping feature, the following prerequisites must be completed:
F
For database mirroring, register both
PRINCINPAL
and
MIRROR
instances that will
be part of the database mirroring pair including the
WITNESS
server.
F
For database mirroring or log shipping, the collation and sort order should match
between the server instances.
F
Choose servers for the primary instance, secondary instance, and an optional
monitor server instance; no specific or special hardware configuration is required for
log shipping.
F
SQL Server 2008 introduced backup compression, which is an Enterprise edition
feature, and beginning in SQL Server 2008 R2 Standard edition supports the backup
compression. When creating the log shipping configuration, we can choose the
backup compression for transaction log backups.
F
Create a file share for the transaction log backups on a separate server, which is not
a part of the log shipping configuration for maximum availability of database backups.
F
Ensure that the primary database recovery model is set to
FULL
and perform a full
database backup; set the backup schedule for the primary database and create a
folder on a secondary server into which the log backup files will be copied by the log
shipping process.
You should set up a single share as the backup directory (a backup share). This ensures
that after role switching between the principal and mirror servers, backup jobs continue to
write to the same directory as before. A best practice is to ensure that this share is located on
a different physical server from the servers hosting the databases involved in mirroring and
log shipping.
How to do it...
The following steps are required in order to manage log shipping in a database
mirroring environment.
1. The database mirroring session must be established between the partners before the
log shipping process begins.
2. The principal database is configured as the log shipping primary database.
3. Additionally, the mirror database must be configured as the log shipping primary
database. The log shipping secondary database is set on a different server instance,
which is not a part of database mirroring partners.
Search WWH ::
Custom Search