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
How to disconnect from a sql server using mssql_close()?
How to Check if table exists in sql server?
Where are SQL server users names and passwords are stored in sql server?
What is query parameter in ssrs?
What is sql server 2000 work load governor?
How do I start sql server 2017?
What is difference between clustered index and non clustered index?
Where to find ntwdblib.dll version 2000.80.194.0?
What are the differences between triggers and stored procedures?
what is a check constraint?
How to enter unicode character string literals in ms sql server?
What function does a database engine serve in the sql server?
What are various aggregate functions that are available?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the default port for SQL Server over a firewall?