Problem causing me to have to restore tlogs WITH MOVE

[CPNZ]

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.STAN DBY’
,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-Disc...ict259104.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=893187

[Mike Epprecht \(SQL MVP\)]

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: mi**@epprecht.net

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

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

"CPNZ" <Us************@dbForumz.com> wrote in message
news:4_***************************************@dbf orumz.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.STAN DBY’
,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-Disc...ict259104.html
Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=893187