Re: Problem causing me to have to restore tlogs WITH MOVE
- From: "Mike Epprecht \(SQL MVP\)" <mike@xxxxxxxxxxxx>
- Date: Wed, 28 Sep 2005 17:02:22 +0200
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@xxxxxxxxxxxx
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"CPNZ" <UseLinkToEmail@xxxxxxxxxxxx> wrote in message
news:4_893187_310bbcc5d254070f4ec093ff3da778dc@xxxxxxxxxxxxxxx
>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
.
- References:
- Prev by Date: Re: VB 6 & SQL Database: How can I create reports with charts ?
- Next by Date: Re: Fast Date Ranges Without Loops In SQL Server 2000
- Previous by thread: Problem causing me to have to restore tlogs WITH MOVE
- Next by thread: Database Replication
- Index(es):
Relevant Pages
|
