I have a database i am m oving to another server, during the process I am moving the data and log files to another drive.(Which I have done countless times before with no problems)
The problem I am having is after I restore the database using the following statement :
RESTORE DATABASE CMAMSPROD FROM DISK = 'C:\Databasename.BAK'
WITH STANDBY = 'D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\Databasename\databasename.STANDBY'
,MOVE 'Databasename_Data' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\Databasename_Data.mdf'
,MOVE 'Databasename_Log' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\Databasename_Log.ndf'
I get these errors when trying to restore transaction logs :
[SQLSTATE 42000] (Error 3156) Device activation error. The physical file
name 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Databasename_log.ldf' may be incorrect.
[SQLSTATE 42000] (Error 5105) File 'Databasename_Log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Databasename_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Has anyone encountered the same problem? This has me stumped, although restoring the tlog with move, and standby works....this is not how it should work.
>> Stay informed about: Problem causing me to have to restore tlogs WITH MOVE