Answer Posted / chhavi...sql server dba_431,44
Let me rephrase it first...Limitation in logshipping...
1. Automatic failove is not possible.
2. There will be some data loss because you can't configure
the backup job to run less than 2 minutes.
But insted of these limitation we have many advantages:
1. We can configure the restore job to run with sufficint
delay to recover from user's error.
2. We can have more number of secondaries
3. Also provide log backup backup which can be utilize in
point in time recovery
| Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
Can we add an identity column to decimal datatype?
What is a trigger what are the advantages of trigger?
Explain what role entity and relationship play in an ER diagram.
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
Why should one not prefix user stored procedures with ‘sp_’?
How to throw custom exception in Stored Procedure?
Explain the microsoft sql server delete command? : SQL Server Architecture
In how many ways you can invoke ssrs reports?
Explain having clause?
Does any body please help me what question's have asked for SSRS in the interview?
What are the elements of dbms?
Do you know data definition language, data control language and data manipulation language?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What are unicode character string data types in ms sql server?
How ssrs maintain security?
