RESTORE (SQLSERVER 2008) VIA BAT

• douglasferreira.tech

  Grasshopper

  Points: 15

  More actions

  July 14, 2016 at 8:47 am

  #104327

  Dears, good morning !

  I inciante in database and am developing a script for optimization routines in SQLServer.

  This bat is being run in a Windows environment, and to perform the bat the backup files are displayed on the screen, but would like a solution that, after we select a backup, it should be completed in the corresponding syntax restore, for example ( RESTORE DATABASE test FROM DISK = N'C: \ SQLServer \ Backup \ bkp_xpto.bak '). I wish the selected backup was automatically filled in restore syntax, or I could just type up the name, the restore syntax .--> RESTORE DATABASE test FROM DISK = N'C: \ SQLServer \ Backup \ bkp_XPTO. bak. ' )

  Note: The backup files are never replaced, they are geradoscom date and time.

  Attached follows the prints.

  att,

  Douglas Ramos

  Em anexo, segue os prints.

  Att,

  Douglas Ramos