Restore a database using a batch file

• johnymoss

  SSC Veteran

  Points: 279

  More actions

  March 8, 2012 at 4:42 am

  #254373

  Hi Guys

  Is there a simple way to restore a database to a previous state(i.e. from a .bak file) from a batch file?

  Basically I want to be able to use a DB for demo purposes, fill it full of meaningless data, then afterwards just run a batch file to overwrite it with an empty backup... rather than doing a restore through SQL server..

  Any help would be much appreciated.

  Cheers

  John

• Mr. Holio

  Hall of Fame

  Points: 3328

  More actions

  March 8, 2012 at 4:46 am

  #1456451

  Do a google search on SQLCMD

  __________________________
  Allzu viel ist ungesund...

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  March 8, 2012 at 4:51 am

  #1456456

  or powershell invoke-sqlcmd.

  Both of these can be scheduled. Its also possible to make the file name dynamic and/or loop through multiple files in a folder.

  It depends on how flexible you want the process to be.