Restore Issue

• kirankritapure

  Grasshopper

  Points: 15

  More actions

  March 10, 2016 at 12:18 am

  #324815

  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?

• VastSQL

  SSC-Dedicated

  Points: 36188

  More actions

  March 10, 2016 at 12:26 am

  #1864177

  Check the database name from which the backup is taken initially. You can edit the physical name but logical name only when you create a new DB.

  Experts please correct if I am wrong.

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  March 10, 2016 at 4:16 am

  #1864195

  That might be due to Third Party backup internals. We are using Avamar and while restore it also do the same thing but restore will be on development/test it should be fine. After all I am worried about data only.

  HTH

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  March 10, 2016 at 10:10 am

  #1864298

  kirankritapure (3/10/2016)

  ---

  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?

  Could you please provide the specific details (database name, file names)?

  Also post the following:

  SELECT DB_NAME(DATABASE_ID) AS DATABASENAME,

  [NAME],

  PHYSICAL_NAME AS [FILE LOCATION]

  FROM sys.master_files

  where DATABASE_ID > 4

  ORDER BY DATABASENAME

• Grant Fritchey

  SSC Guru

  Points: 398999

  More actions

  March 10, 2016 at 11:19 am

  #1864329

  Take direct control of the restore process through scripts rather than relying on some GUI. You can certainly name the files any way you wish when using those products you mention.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning