Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / parker
Logshipping is a new feature of SQL Server 2000. We should
have two SQL Server - Enterprise Editions. From Enterprise
Manager we can configure the logshipping. In logshipping
the transactional log file from one server is automatically
updated into the backup database on the other server. If
one server fails, the other server will have the same db
and we can use this as the DR (disaster recovery) plan.
| Is This Answer Correct ? | 28 Yes | 12 No |
Post New Answer View All Answers
What are trace files?
What are the different types of locks in the database?
What is transact-sql ddl trigger?
What is compression - row-level and page-level compression?
Describe the functionalities that views support.
What is a non clustered primary key?
What is a Join and explain its types?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Define synonym?
what is an index? : Sql server database administration
What is log cache in sql server?
What are locks in sql?
Explain datetime2 data type in sal server 2008?
List some case manipulation functions in sql?
Why it is recommended to avoid referencing a floating point column in the where clause?
