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
Why and when do stored procedure recompile?
What guidelines should be followed to help minimize deadlocks?
How can you find out which stored procedures are recompiling?
What causes index fragmentation?
Why is the need for data conversion transformations?
What are the database roles? : sql server security
Explain few examples of stored procedure over triggers?
What is sql profiler. What are the default templates with it? : sql server database administration
explain the storage models of olap? : Sql server database administration
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain use of expression builder.
Explain identity in sql server?
What are the different types of data sources in ssrs?
What is acid properties?
What is the difference between migration and upgradation in sql server?