Database Reference
In-Depth Information
Getting ready
To setup and configure the database mirroring environment, ensure the following
requirements are met:
F
All the server instances are on the same level of service packs and hotfix packages
for the Windows operating system and SQL Server services.
F
Ensure that the SQL Server edition is DataCenter, Enterprise, or Standard.
F
When any of the database mirroring partners is using Standard Edition (SE), then the
other partner must be same version; the SE supports the full safety mode only, which
is a single-threaded operation.
F
Ensure the network connectivity is consistent with no latency. Establish the endpoint
configuration for each server that is part of the database mirroring pair. The endpoint
uses the TCP/IP addressing and listening ports for all the communications between
the servers.
F
Use the SSMS tool to register both
PRINCINPAL
and
MIRROR
instances that will be
part of the database mirroring pair including the
WITNESS
server.
F
Ensure the service account (domain account), which is used for database mirroring
has
GRANT
access on the endpoint for access to be allowed for each server to the
other.
F
Ensure that the database that is to be mirrored is using the FULL database recovery
model, as database mirroring is performed based on the transaction log sequence.
F
Ensure that the SQL Server service account is a part of
sysadmin
group on the SQL
Server instances that are part of database mirroring.
F
Perform a full database backup and an immediate transaction log backup from the
source (PRIMARY) server, copy both the backup files to the (MIRROR) server.
F
Restore the database and restore the transaction log with the NORECOVERY option
only, which is until the tail of transactions and to the point of being able to mirror.
F
As a named mirroring instance pair references, let us choose the names as follows,
principal:
DBIAPR
, mirror:
DBIAMR
, and witness:
DBIAWT
Ensure that all the mirroring partners consist of
identical folder names and paths to avoid any
mismatch during the RESTORE operation.
Search WWH ::
Custom Search