Posted by Mike Epprecht \(SQL MVP\) on 09/28/05 18:02

Hi

Check that your paths supplied are correct. Copy and past them into Windows
Explorer to see if they are right.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"CPNZ" <UseLinkToEmail@dbForumz.com> wrote in message
news:4_893187_310bbcc5d254070f4ec093ff3da778dc@dbforumz.com...
>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: Problem causing me to have to restore tlogs WITH MOVE
• Prev in forum: Re: Problem causing me to have to restore tlogs WITH MOVE
• Thread view: Re: Problem causing me to have to restore tlogs WITH MOVE

[Reply to this message]