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 is clustered primary key?
Do you know spatial data types - geometry and geography in sql server 2008?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Is sql server 2016 free?
What is the primary use of the model database?
What is the index requirement in SQL Azure?
What are key constraints?
What is the difference between function and stored procedure in sql server?
can any body tell me how to know the password of current user in sql server
What is openrowset sql server?
how will add additional conditions in sql?
How to convert a table data in XML format in sql server?
what is hash nonclustered index
How do I view a procedure in sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
