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 do you understand by recursive stored procedures?
What happens on checkpoint?
Find first and last day of current month in sql server
What is autocommit mode in sql server?
what are the different types of replication you can set up in sql server? : Sql server database administration
What are the types of ssrs?
how can you check the level of fragmentation on a table? : Sql server administration
What triggers long term care?
explain the storage models of olap? : Sql server database administration
What is Replication?
How can you insert null values in a column while inserting the data?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Explain unique key in sql server?
What happens if null values are involved in datetime operations?
How many replicas are maintained for each SQL Azure database?