Restore from 2008 to 2014 messing up file names

• niks.06241

  Grasshopper

  Points: 17

  More actions

  March 10, 2016 at 12:13 am

  #325613

  I am restoring few databases from 2008 backups to 2014. I used litespeed and SQL server native restores. But every time the physical file names are being generated as DBName_1.mdf, DBName_2.ndf etc. It is not matching with the logical file names.

  Anybody has faced similar issue?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 10, 2016 at 1:05 am

  #1864178

  Duplicate post.

  Replies here please: http://www.sqlservercentral.com/Forums/FindPost1768157.aspx

  -- Gianluca Sartori