automating data refresh

• Ramu Poonjolai

  SSC-Addicted

  Points: 451

  More actions

  May 24, 2007 at 9:17 am

  #63073

  Frequently we get request of data refresh. Its curbersome process everytime to take backup from prod and restore in development/test region. I am thinking to automate this process using stored procedure. But I need to pass various parameters to SP to tell where is source, destination, domain, etc.,

  Anyone has better ideas/suggestions. Do you have any script reg.

  Thanks,

  Ramu

• CGSJohnson

  SSCertifiable

  Points: 7208

  More actions

  May 25, 2007 at 11:09 am

  #709044

  Log-shipping would ensure that you've got a copy of the database in read-only status though, but albeit available.  I hope that this helps.  Thanks.