Errors similar to this may appear in the SQL Server error logs:
spid14 Device activation error. The physical file name 'D:\MSSQL\reporting_Data.MDF' may be incorrect.
spid14 Device activation error. The physical file name 'D:\MSSQL\reporting_Log.LDF' may be incorrect.
spid12 Device activation error. The physical file name 'D:\ABC_Working\Data\ABC_DB_Data.MDF' may be incorrect.
spid13 Device activation error. The physical file name 'D:\MSSQL\Databasename_Log.LDF' may be incorrect. 2011-11-18 10:43:33.40 spid14
Starting up database 'databasedb'.
spid9 udopen: Operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device D:\MSSQL\databasename\databasename_Data.MDF.
Starting up database 'LiteSpeedCentral'.
udopen: Operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device D:\MSSQL\ABCD_Data.MDF.
spid14 Starting up database 'Databasename'.
udopen: Operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device D:\MSSQL\Databasename_Data.MDF.
Starting up database 'databasedb'.
FCB::Open failed: Could not open device D:\MSSQL\Databasename_Data.MDF for virtual device number (VDN) 1.
FCB::Open failed: Could not open device D:\MSSQL\ABCD_Data.MDF for virtual device number (VDN) 1.
FCB::Open failed: Could not open device D:\MSSQL\databasename\databasename_Data.MDF for virtual device number (VDN) 1.
Starting up database 'reporting_temp'.
Starting up database 'ABC_DB'.
Starting up database 'SS_DB'.
udopen: Operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device D:\MSSQL\reporting_Data.MDF.
udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening
Full text catalogues are in a different location than the database recovery destination
WORKAROUND:
Direct the recovery to the location where the database has the full catalogue text files on the destination server) using a script with the WITHMOVE parameter.
exec master.dbo.xp_restore_database @database = N'databasedb' ,
@filename = N'D:\Backup\databasedb_Full_20111115213345.bak',
@filenumber = 1,
@with = N'STATS = 10',
@with = N'MOVE N''databasedb'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\databasedb.mdf''',
@with = N'MOVE N''databaselog'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL\data\database_log.ldf''',
@affinity = 0,
@logging = 2
