How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
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
Are resultset updatable?
What is the name of the Database which IBM mainframe uses?
What is bit data type?
What is the difference between varchar and nvarchar?
Explain active/passive and active/active cluster configurations?
Do you know what is rank function?
How you provide security to cube? : sql server analysis services, ssas
What are examples of triggers?
tell me the disaster recovery plan
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What are different types of statements that are supported by sql?
Explain about link server in sql server?
What is stretch database in sql server?
What is normalization? Explain its different types?
What is update_statistics command?