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 an indice?
How to insert multiple rows with a subquery?
If a table does not have a unique index, can a cursor be opened on it?
What is a rollup clause?
How can I check if a view exists in a sql server database?
What is a print index?
Would you store your query in a ssrs report or a database server? State the reason why?
How to convert character strings into numeric values?
What is the difference in accessing db between sql server vs sql azure?
How to select all columns of all rows from a table with a select statement in ms sql server?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
whats the maximum size of view state??
wat wil hapn if we give the both read and deny read permission to user?
What is a benefit of using an after insert trigger over using a before insert trigger?
What do you mean by a Composite primary key?