Interested to Buy Any Domain ? << Click Here >> for more details...
How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?
- 4 Answers
- 19677 Views
- IBM, I also Faced
- E-Mail Answers
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 the difference between value type and reference type?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is log in sql server?
Can binary strings be used in arithmetical operations?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
What does top operator do?
Comment,Datatypes are unlimited
What are the commands used in DCL?
what is Equity join?
What is sub-query in sql server? Explain its properties.
What is the difference between an index and a unique index?
How many types of the database links?
-
Oracle (3253) - 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)
