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
Explain use of expression builder.
How to create user messages with print statements in ms sql server?
What is unique key constraint?
How would you add a section to a table?
What is lookup override?
Do you know what are acid properties?
List types of tables in SQL Azure?
Can we use max in where clause?
Explain the relational database management system (rdbms)?
what is the maximum size of a row? : Sql server database administration
Explain cursor as data base object?
What is the process of normalization?
What do you understand by a view?
How do I create a partition table in sql server?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration