How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
- 4 Answers
- 18712 Views
- IBM, I also Faced
- E-Mail Answers
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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the optimization being performed in oracle and SQL Server?
Why we need sql server?
What is #temp and @table variable in SQL server?
What is the default order of an order by clause?
What do you understand by a view? What does the with check option clause for a view do?
Name 3 ways to get an accurate count of the number of records in a table?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is the size of transaction log file?
What is stored in the mssqlsystemresource database? : sql server database administration
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
what is the difference between a primary key and a unique key? : Sql server database administration
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
what is a correlated sub-query? : Sql server database administration
What is user defined datatypes and when you should go for them?
What are different types of constraints?
