Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the advantages of using stored procedures in sql server?
How to create sub reports?
What is database white box testing?
What is a transact-sql statement batch in ms sql server?
What is the template in sql?
Why the trigger fires multiple times in single login?
What is a trigger and its types?
What are types of scd? : sql server analysis services, ssas
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How to fine-tune reports?
What security features are available for stored procedure?
How to create a store procedure with encryption?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is the difference between for trigger and after trigger?
What is the difference between having clause and where clause in sql server?
