Posted by CPNZ on 09/28/05 06:36

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.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Discussions-Problem-causing-restore-tlogs-MOVE-ftopict259104.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=893187

• Next in forum: Re: Access Control List (structure) invalid - updating Virtual directory information
• Prev in forum: Re: Performance and second table
• Thread view: Problem causing me to have to restore tlogs WITH MOVE

[Reply to this message]