DBA Wiz

An automatic failover is a switching role that causes the mirror server to take over the role of the principal server and bring its copy of the database online as the principal database. It involves high-safety mode and requires the presence of the mirror server and a witness server. The database should be synchronized and the witness must be associated to the mirror server. The job of the witness is to confirm whether a given partner server is up and operating. If the connection of the mirror server to the principal server is lost but the witness server is still connected to the principal server, the mirror server will not initiate a failover.

Failover clustering is a process in which more than one server is configured to host a single instance of SQL Server 2005/2008. The database will still be available if a server in the cluster fails. The cluster of servers contains shared disk that holds the data in the database. This type of configuration is also known as virtual server.

Database Publishing Wizard uses the following modes to deploy an SQL database:
Script mode: In this mode, Wizard generates a single SQL script file that a user can run manually on the target server for recreating the database schema and contents.
Web service mode: In this mode, Wizard connects to a Web host environment service and copies the content of a source database into a target database directly.

There are three types of database schemas, which are as follows:
Conceptual schema: It is also called a conceptual data model. It is a map of concepts and their relationships. It is used to describe the semantics of an organization.
Logical schema: It specifies problem domain in terms of a particular data management technology without being specific to a particular database management.
Physical schema: It is a term used in relation to data management. According to the ANSI four-schema architecture, it was the view of data that involved data management technology.

A database schema is the structure of a database. It is described in a formal language supported by the Database Management System (DBMS). It is a collection of database objects such as tables, views, sequences, synonyms, clusters, indexes, database links, procedures, functions, and packages. In a relational database, the database schema defines tables, fields, and relationships between the fields and tables. A database schema is stored in a data dictionary.