Chapter 12 DBMS-Specific Features

Databases

For information about creating a database object, see "Creating a database" section in the Getting Started with Data Modeling chapter.

The following extended attributes are available on the Mirroring tab:

Name Description
Enable mirroring Enables mirroring for the database.

Scripting name: EnableMirroring
Partner/ Witness Specifies the role that the database will play in the mirroring relationship. You can choose between:

  • Partner – the database is either a principal or mirror database.
  • Witness – the database acts as a witness to a mirroring relationship. A SET WITNESS clause affects both copies of the database, but can only be specified on the principal server. If a witness is set for a session, a quorum is required to serve the database, regardless of the SAFETY setting.


Scripting names: Partner, Witness
Options Specifies mirroring options for the database. You can choose between:

  • <None>
  • server
  • off
  • failover
  • force_service_allow_data_loss
  • resume
  • safety full
  • safety off
  • suspend
  • timeout


Scripting name: MirrorOptions
Server For partner mirroring, specifies the server network address of an instance of SQL Server to act as a failover partner in a new database mirroring session.

For witness mirroring, specifies an instance of the Database Engine to act as the witness server for a database mirroring session.

Scripting name: MirrorServer
Time-out [if partner is selected] Specifies the time-out period in seconds. The time-out period is the maximum time that a server instance waits to receive a PING message from another instance in the mirroring session before considering that other instance to be disconnected.

Scripting name: TimeOut

 

Copyright (C) 2008. Sybase Inc. All rights reserved.