how to do Automated restore script for UAT refresh for all the Database

• surya_7482

  SSC-Addicted

  Points: 445

  More actions

  February 22, 2012 at 11:20 am

  #257256

  how to do Automated restore script for UAT refresh for all the Database?

  Thanks in adv!!!!

• Lowell

  SSC Guru

  Points: 323546

  More actions

  February 22, 2012 at 11:23 am

  #1450470

  pretty loose on the details.

  do you have to copy the backup(s) from somewhere to the UAT server now?

  do you have the current backup(s) scripted out already so you can just run the script(s) to restore?

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• sengeet86

  Ten Centuries

  Points: 1252

  More actions

  February 22, 2012 at 11:23 am

  #1450471

  check this blog.

  http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

  java programming

• ggoble

  Hall of Fame

  Points: 3337

  More actions

  February 22, 2012 at 11:23 am

  #1450472

  Check http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  February 22, 2012 at 11:34 am

  #1450480

  Do the restored databases have to be read write?

  What about customer sensitive data? Do you need to remove details which could identify customers? Card numbers?