How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
- 4 Answers
- 18718 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gaurdas06
Four jobs will create :
1. Backup job - to take the backup of the logs
2. Copy job - to copy the logs to the destination/secondary server
3. Restore job - to restore logs on the target server and lastly
4. alert job - to send alert or report for any errors
Thnx
Andy
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are entities and relationships?
What is the Control Flow in SSIS
How to return the date part only from a sql server datetime datatype?
What are the common performance issues in sql server?
Explain alternate key, candidate key and composite key in sql server?
Does the order of columns in update statements matter?
what are acid properties? : Sql server database administration
How to create a testing table with test data in ms sql server?
Do I need a report server to run reports in my application?
What is a rollup clause?
What is the difference between count and distinct count?
How to test values returned by a subquery with the in operator?
What is check constraint in sql server?
Explain the categories of stored procedure?
How you can get the list of largest tables in a database?
