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
merlin
Moved byDarren GosbellMVPFriday, July 17, 2009 4:41 AMThis is not an SSAS question it is a SQL backup question (From:SQL Server Analysis Services)