Sqlserver 7.0 backup db to sqlserver 8.0 RRS feed

  • Question

  • hello,

          I having sqlserver 7.0 's backup file ,i need to restore/attach the same

    database to sqlserver.

           When i try to restore following error

         device activation error.
    The physcial file name 'c\program file\mssql7\data\ampcms_data.mdf' may be incorrect.file ampcms_data cannot be restore to 'c\program file\mssql7\data\ampcms_data.mdf'.use with move to identity for file.

    it is possible to restore,its contain import data.

    thank in advance

    • Moved by Darren GosbellMVP Friday, July 17, 2009 4:41 AM This is not an SSAS question it is a SQL backup question (From:SQL Server Analysis Services)
    Friday, July 17, 2009 4:23 AM

All replies