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 is a unique key constraint?
What is a non clustered primary key?
What is view in sql?
What is the difference between the 2 operating modes of database mirroring?
Define primary key?
How does a profiler work?
What stored by the tempdb ? : sql server database administration
When should you use an instead of trigger?
What is similarity and difference between truncate and delete in sql?
How to view existing indexes on an given table using sys.indexes?
How many clustered indexes there can be on table ?
How to get the number of affected rows?
What is ms sql server reporting services?
What do you know about normalization and de- normalization?
What happens if we shrink log file in sql server?
