VB script for restoreing DB

• hemanthrajuster

  Newbie

  Points: 7

  More actions

  December 12, 2007 at 5:55 am

  #184991

  Hemanth here,

  Please suggest for specifying MDF and LDF file name and path while restoring database using vb script

  i have script which works only for default path of DB backup

  Regards

  Hemanth

• Piotr.Rodak

  SSCrazy Eights

  Points: 9376

  More actions

  December 12, 2007 at 10:56 am

  #759513

  Check for the MOVE option in the restore database statement. Also, to get list of files, read about restore filelistonly.

  Piotr

  ...and your only reply is slàinte mhath

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 13, 2007 at 10:41 am

  #759942

  Hi,

  Check the following links:

  http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/[/url]

  http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=87

  Regards,

  Ahmed