How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
Answer Posted / naga
log shipping:
1)backup job
2)copy job
3)restore job
4)alert job
database mirroring
1)database mirroring monitor job
replication
1)agent history cleanup job
2)distribution clean job
3)expire subscription clean job
4)replication agent checkup job
5)replication monitor refresh for distributor
6)reinitialize subscriptions having data validation failures
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is database isolation in sql server? : sql server database administration
What are the purpose of Normalisation?
What are the types of database recovery models?
How to insert and update data into a table with "insert" and "update" statements?
Explain what is the difference between a local and a global temporary table?
Do you know hot add cpu in sql server 2008?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Do you know how to store and query spatial data?
What are number line correlation administrators will use while working with a subquery?
What is a full text index?
How to use the inserted and deleted pseudo tables?
What is the difference between substr and charindex in the sql server?
What are the new features in sql server 2016?
What are the different authentication modes in sql server? How can it be changed?