answersLogoWhite

0

SQL mirroring, or database mirroring, is supposed to be able to increase the database space and the boost the protection of the database to make it a secure area.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is mirroring in sql server 2008?

Database mirroring maintains two copies of a single database that must reside on different server instances of SQL Server Database Engine. Typically, these server instances reside on computers in different locations. Starting database mirroring on a database, initiates a relationship, known as a database mirroring session, between these server instancesDatabase mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the mirror database as quickly as possible. Redoing is accomplished by sending a stream of active transaction log records to the mirror server, which applies log records to the mirror database, in sequence, as quickly as possible. Unlike replication, which works at the logical level, database mirroring works at the level of the physical log record. Beginning in SQL Server 2008, the principal server compresses the stream of transaction log records before sending it to the mirror server. This log compression occurs in all mirroring sessions


What is the meaning of the abbreviation 'SQL'?

Structured Query Language, SQL, is used for retrieving and managing data in databases.


What is the full meaning if nDF files in SQL?

Secondary storage File


Salient features of SQL?

Database Mirroring--> Extend log shipping capabilities with the database mirroring solution. You will be able to use database mirroring to enhance availability of your SQL Server systems by setting up automatic failover to a standby server. Online Restore--> With SQL Server 2005, database administrators are able to perform a restore operation while an instance of SQL Server is running. Online restore improves the availability of SQL Server because only the data being restored is unavailable; the rest of the database remains online and available. Online Indexing Operations--> The online index option allows concurrent modifications (updates, deletes, and inserts) to the underlying table or clustered index data and any associated indexes during index data definition language (DDL) execution. For example, while a clustered index is being rebuilt, you can continue to make updates to the underlying data and perform queries against the data. Fast Recovery--> A new faster recovery option improves availability of SQL Server databases. Administrators can reconnect to a recovering database after the transaction log has been rolled forward.


What is the medical term meaning good cholesterol?

You know, the thing about SQL is, that there is virtually nontihg that can replace it.Does anyone know if a substitute exists for sql? I mean besides MS SQL and Oracle and all that jazz. Thanks.


What is the full meaning if MDF files in SQL?

MDF = Master Database File


What is the full meaning of LDF file in SQL?

list data filelog database file


What is RAID level 1 also called?

Disk mirroring


What is the SQL of World of Warcraft?

there is no sequel to WOW it is changing always through patches and expansion packs and its wary existence kills a great RTS game line. (sorry if i was using the wrong meaning for SQL)


Where could someone find an SQL formatter?

One can find an SQL formatter from: SQL Format, Free Formatter, Poor SQL, T-SQL Tidy, Stack Overflow, SQL Inform, Apex SQL, SQL Parser, Red Gate software, to name a few.


What is the difference between T-sql and sql?

T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.


When was The Mirroring Shadow created?

The Mirroring Shadow was created on 2009-11-16.