Chapter 15 DBMS-Specific Features

Databases

For information about creating a database object, see the "Creating a database" section in the Physical Data Model Basics 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 name: 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

 

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