How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
Answers were Sorted based on User's Feedback
Answer / naga
log shipping:
1)backup job
2)copy job
3)restore job
4)alert job
database mirroring
1)database mirroring monitor job
replication
1)agent history cleanup job
2)distribution clean job
3)expire subscription clean job
4)replication agent checkup job
5)replication monitor refresh for distributor
6)reinitialize subscriptions having data validation failures
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Which are the new data types introduced in sql server 2008?
What is a self join in sql server?
What is resource db in sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is sql server used for?
What is SQL server agent?
How do I save a stored procedure in sql server?
Explain different types of Normalization.
1 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
What are the advantages of log shipping?
What are the joins in sql server? : sql server database administration
what is a join? : Sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)