Interested to Buy Any Domain ? << Click Here >> for more details...
How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
- 4 Answers
- 19668 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
What do you think of this implementation? Can this be implemented better?
What is the log shipping?
What is SubQuery in SQL Server 2008
How to rename databases in ms sql server?
Explain the steps needed to create a scheduled job?
Why would you use sql agent?
Explain “row_number()” in sql server with an example?
What is a join in sql? What are the types of joins?
What is partition, how will you implement it? : sql server analysis services, ssas
What is identity?
Explain the different types of backups available in sql server? : sql server database administration
When to use null data driven subscription?
How can I check that whether automatic statistic update is enabled or not?
how to create “alternate row colour”?
What are distributed partitioned views?
