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 statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

Explain the different types of joins?

0 Answers  

What is merge replication?

0 Answers  

What is the difference between seek predicate and predicate?

0 Answers  

What is the difference between delete and truncate statements?

0 Answers  

what is raid? : Sql server database administration

0 Answers  

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

What is filter index?

0 Answers  

What are the 7 disadvantages to a manual system?

0 Answers  

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

What is a field in a table?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories