Problem causing me to have to restore tlogs WITH MOVE

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
.

Relevant Pages

  • Re: Migration ?
    ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2003 Enterprise CA & Restored State
    ... existing database log files and recover the state back to the last completed ... and not lose any issued certs. ... restore operation. ...
    (microsoft.public.win2000.security)
  • Re: Exchange Recovery Question
    ... I know that it does not purge any outdated log files. ... I performed an offline backup of the damaged database and associated ... log files prior to starting my restore. ... which does backups by the volume shadow copy API, ...
    (microsoft.public.exchange.admin)
  • Re: Information Store refuses to mount
    ... If you know that it is the case, you should check of the log files ... (use eseutil /mh, there is a log required range). ... Assuming e00.log is really lost (and needed as per database state) you would ... need to restore from backup. ...
    (microsoft.public.exchange2000.information.store)
  • Re: Restore leaves DB in Loading state
    ... state of loading after the database restore - rather than in read only. ... > leave SQL restore hanging until it could write to that file. ... > I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)