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

Explain different types of index?

0 Answers  

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

What is SubQuery in SQL Server 2008

0 Answers   HCL,

What is normalization of database?

0 Answers  

Define outer join?

0 Answers  

Which are the new data types introduced in sql server 2008?

0 Answers  

What are the differences between triggers and stored procedures?

0 Answers  

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

Explain the benefits of user-defined functions?

0 Answers  

What is Index ? Explain its Types?

2 Answers   ADP,

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

What is resource governor in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories