Restore: Device Activation Error

• GivThx

  SSCommitted

  Points: 1758

  More actions

  November 6, 2002 at 2:07 pm

  #159190

  Hi, all

  I want to move data from SQL 7.0 to SQL 2000 using backup/restore not using Detatch/Attach.

  When I do backup and restore into SQL 2000,

  I got an error message called " Device Activation error"..

  Funny thing is I inherited this DB so I dont know why whoever created this DB used logical name like this "409_Data".. Actually when I run sp_helpdb, I can see DB name with quatation mark..I think because of this "", restore fails..

  Any Idea???

  Thx in advance

  Jay

• GivThx

  SSCommitted

  Points: 1758

  More actions

  November 6, 2002 at 2:31 pm

  #440543

  Hi, All..

  I used this script and worked...

  /*****************************

  RESTORE FILELISTONLY

  FROM DISK = 'f:\test\110602USA.bak'

  RESTORE DATABASE USA

  FROM DISK = 'f:\test\110602USA.bak'

  WITH RECOVERY,

  MOVE '"409_dat"' TO 'E:\SQLData\USA.mdf',

  MOVE '"409_log"' TO 'G:\SQLLog\USA.ldf'

  GO

  ****************************/

  I hope this can help..

  Thx

  Jay