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.
Wiki User
∙ 11y ago
Add 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.
Which SQL keyword is used to retrieve only unique values?
DISTINCT
What are the salient features of a lyric?
Finding salient features of a lyric is easy. The salient is changes in the economy and government.
What is salient features of MS Word 2000?
What is salient features of MS Word
What is the explanation for the salient features of windows?
write a detail note on microsoft window write its salient features
What are the salient features of verbal and written communication?
salient frature of written communication
What is the meaning of salient features?
Salient features mean noticeable, clear to see or obvious features. As an application example: "In his letter, he claimed that he just wanted to say hello, but the more salient message to me was that he was lonely and badly needed a friend to talk to."
What are the salient features of Gandhi's basic education?
the salient feature of gandhian concept of basic education is
What are the salient features of Chinese constitution?
There are several salient features of the Chinese constitution. Some of these include a written document, flexible constitution, and a unitary system.
Write a sentence using salient?
It was a lengthy discussion, the salient point of which was that we need to be more careful to avoid electrocution.
Salient features of bazee.com?
how to bid for a iteam in bazee.com?
What are the Salient features of computerized accounting system?
lolllxzzz
Salient features of economic system of Islam?
ponka
What are the salient features of Pune city?
it is mad and dumbo
