Microsoft SQL Server forum - Problem causing me to have to restore tlogs WITH MOVE

Author

Problem causing me to have to restore tlogs WITH MOVE

CPNZ

2005-09-28, 3:24 am

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\databas
ename.STANDBY’
,MOVE ’Databasename_Data’ TO ’D:\Program Files\Microsoft SQL
Server\MSSQL\Data\Da
tabasename_Data.mdf’
,MOVE ’Databasename_Log’ TO ’D:\Program Files\Microsoft SQL
Server\MSSQL\Data\Da
tabasename_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\Da
tabasename_log.ldf’ may be incorrect.
[SQLSTATE 42000] (Error 5105) File ’Databasename_Log’ cannot be
restored to ’C:\Program Files\Microsoft SQL
Server\MSSQL\Data\Da
tabasename_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-Dis...pict259104.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=893187

Mike Epprecht \(SQL MVP\)

2005-09-28, 11:24 am

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@dbFor
umz.com> wrote in message
news:4_893187_310bbc
c5d254070f4ec093ff3d
a778dc@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\databas
ename.STANDBY’
> ,MOVE ’Databasename_Data’ TO ’D:\Program Files\Microsoft SQL
> Server\MSSQL\Data\Da
tabasename_Data.mdf’
> ,MOVE ’Databasename_Log’ TO ’D:\Program Files\Microsoft SQL
> Server\MSSQL\Data\Da
tabasename_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\Da
tabasename_log.ldf’ may be incorrect.
> [SQLSTATE 42000] (Error 5105) File ’Databasename_Log’ cannot be
> restored to ’C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\Da
tabasename_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-Dis...pict259104.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=893187

Sponsored Links