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
Do you think BCNF is better than 2NF & 3NF? Why?
Can the “if update (colname)” statement be used in a delete trigger?
How to start and end transact-sql statements?
What is a livelock?
How to count rows with the count(*) function in ms sql server?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is bcp? When does it used?
What are different replication agents and what's their purpose? : sql server replication
What is row-level compre?
How can we migrate from SQL server to SQL Azure?
What do you understand by user-defined function in the sql server?
Explain ranking functions?
What is federation member?
How you would rewrite the sql query to return the customerid sorted numerically?
In what three ways is the return statement used in a stored procedure?
