restore with modify datafiles

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  March 20, 2014 at 12:22 pm

  #305338

  I need to restore the databases since the datafile names are same in server so i need to modify the datafiles (primary\log files ) with a new file names while restoring with move .

  any query for this .

• joshdbguy

  SSCertifiable

  Points: 7707

  More actions

  March 20, 2014 at 1:00 pm

  #1698859

  You need to explicitly change the names through a script,

  ALTER DATABASE [DATABASE NAME] MODIFY FILE (

  NAME = [Old Logical Name]

  , NEWNAME = [New Logical Name]

  )

  GO