Interested to Buy Any Domain ? << Click Here >> for more details...
How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
- 4 Answers
- 19505 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 ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to transfer data from a cursor to variables with a "fetch" statement?
What is BCNF? How is it better than 2NF & 3NF?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Explain differentiate between a having clause and a where clause?
Does a specific recovery model need to be used for a replicated database? : sql server replication
List out the differences between the clustered index and non-clustered index in sql server?
What are the options which must be set to allow the usage of optimistic models?
Explain what are commit and rollback in sql?
What is the difference between a check constraint and a rule?
What are the different kinds of ssrs reports?
How to connect php with different port numbers?
What is change data capture (cdc) in sql server 2008?
How do you run a trace?
Explain temporary table vs table variable by using cursor alternative?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
