0
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.
Still curious? Ask our experts.
Chat with our AI personalities
Vivi
Judy
ProfessorAdd your answer:
Earn +20 pts
What Is ANSI SQL?
ANSI SQL is the American National Standards Institute standardized Structured Query Language. ANSI SQL is the base for several different SQL languages such as T-SQL and PL/SQL. ANSI SQL is used to Create, Alter, and View data stored within a database. For more information about ANSI: http://www.ansi.org/ For more information about SQL: http://en.wikipedia.org/wiki/SQL
What are some examples of SQL?
SQL is short for Structured query language. Examples of SQL are seleect * from table_name where <predicates>;
What is a character function in SQL?
Spongebob
What is the function of comparator?
SQL compare is used to compare and synchronize data bases.It can be downloaded as a piece of software.Databases can be compared by SQL compare and synchronized.
Only numeric data types can be added and subtracted in sql?
true
