Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problem causing me to have to restore tlogs WITH MOVE

 
   Database Forums (Home) -> General Discussions RSS
Next:  Can I use many-to-many dimensions in AS2005?  
Author Message
CPNZ




Joined: Sep 27, 2005
Posts: 1



(Msg. 1) Posted: Tue Sep 27, 2005 9:34 pm
Post subject: 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.

 >> Stay informed about: Problem causing me to have to restore tlogs WITH MOVE 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Possibilities to restore an old database - Can someone put me on the right track? I have a .bak file from an MSSQL 7.0 database. I want to restore the database in SQL 2000 or 2005, but the restore fails with the error: "An exception occurred while executing a Transact-SQL statement or batch...

Restore a database to another server - Hi, i am using sql server 2000, and i make daily backups. I want to restore my backup to a test msde database i have. I don't know how i did it last time. -The database name is the same: "web" on both places -The database is located on differe...

Restore sql server express bak file as different db? - I have a bak file of a sql server express database from another server, and I'd like to restore it to my dev box as a different database. Does anyone know how to do this?

Help in Table level restore/backup - Hello All I am currently doing a project on MS SQL Server 2005 where I am in need of table level backup/restore. I know about FILEGROUP. But in our project using FILEGROUP is not feasible. As far as I know MS SQL Server 2005 does not support Table leve...

with nolock problem - Hi, Is there a way to catch every select comming to sql and change it to select with nolock? or how to make database READ UNCOMMITTED permanent? any ideas? Richard
   Database Forums (Home) -> General Discussions All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]