Logshipping setup for all the databases

• KKK17

  SSChasing Mays

  Points: 603

  More actions

  October 19, 2011 at 8:24 am

  #261556

  Hi Experts,

  Can anyone help me in get a script which does logshipping setup for all the databases in an instance.

  We have Disaster Recovery servers for each Prod server. All the databases are configured in Logshipping to DR servers. So Incase of real Disaster, we will bring up the DR server.

  We have an average of 40DBs in every prod and above 100 in few servers too 🙁

  It is becoming a big pain for us when ever we had to re-setup LS when any outage occurs on the servers.

  I am looking for a script which should run from one place does LS setup taking each DB in loop and does backup, copy and restore and then initiate LS jobs both primary and secondary using cmdshell.

  Please help me with the above requirement.

  ~KKK

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 19, 2011 at 9:13 am

  #1396707

  This is the best requirement to justify the use of Central Management Servers.

  Administering Multiple Servers Using Central Management Servers

  http://msdn.microsoft.com/en-us/library/bb895144.aspx