Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 ?    5 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 ?    4 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

What are constraints in microsoft sql server?

0 Answers  

How do I port a number to sql server?

0 Answers  

What do you mean by stored techniques? How would we use it?

0 Answers  

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

What is the native system stored procedure to execute a command against all databases?

0 Answers  

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

Tell me extended events in sql server 2008?

0 Answers  

What is a collation?

0 Answers  

What is update locks?

0 Answers  

How to create function without parameter in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories