1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How many jobs will create for Mirroring, Log Shipping, and
Transactional Replication?

Question Posted / sqldba29

Answers were Sorted based on User's Feedback



How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?..

Answer / anwar

Four jobs will create on logshipping

Is This Answer Correct ?    13 Yes 5 No

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?..

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 ?    4 Yes 0 No

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?..

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 ?    3 Yes 1 No

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?..

Answer / yuvarajputtur

my josbs supper managemen jobs

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL Server Interview Questions

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

How many types of keys are there?

0 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

What does nvl stand for?

0 Answers  

How to transfer a table from one schema to another?

0 Answers   MCN Solutions,




What is clustered index

0 Answers  

Do you know what is openxml in sql server?

0 Answers  

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

Which Model uses the SET concept

0 Answers   Infosys,

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

What are the different type of replication in sql server?

0 Answers  

What is a cube? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories