Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore a development DB form Prod. Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 5:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 14, 2016 10:14 AM
Points: 5,016, Visits: 4,810
I'm trying to restore a development DB form Prod.

I get an error on the Log file but it is a valid path.

I do not get it.

Any help would be greatly appreciated.


RESTORE DATABASE Cypress
FROM DISK = 'I:\Backups\CYP_DW\Full\MyDBDW\MyDBDW_backup_2013_06_24_163430_3276765.bak'
--WITH REPLACE,
WITH NORECOVERY,
MOVE 'MyDBDW' TO 'E:\MSSQL\Data\MyDBDW.mdf',
MOVE 'MyDBDW_Horizon' TO 'E:\MSSQL\Data\MyDBDW_HorizonObjects1.NDF',
MOVE 'MyDBDW_log' TO 'E\MSSQL\Log\MyDBDW.ldf'


Msg 5105, Level 16, State 2, Line 1
A file activation error occurred. The physical file name 'E\MSSQL\Log\MyDBDW_New.ldf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
Msg 3156, Level 16, State 3, Line 1
File 'MyDBDW_log' cannot be restored to 'E\MSSQL\Log\MyDBDW_New.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1466951
Posted Monday, June 24, 2013 6:21 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, August 21, 2016 9:10 PM
Points: 86, Visits: 435
Hi Mate,
Restore process:
You want restore a fresh copy or over writing on exists?
if you are creating a new database please check space for new database.
if you are over writing please check the files
1. location
2. logical name should be source logical name
3.how many files example: 1mdf, 5 ndf and 1ldf. the restore command also should be the same.
Post #1466957
Posted Tuesday, June 25, 2013 12:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 14, 2016 10:14 AM
Points: 5,016, Visits: 4,810
I commented out the Log file and I was able to restore.

That is not necessarily what I want.

I restore quite frequently but not to this Server.

Very strange.



For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1466987
Posted Tuesday, June 25, 2013 12:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 1, 2016 7:08 AM
Points: 2,867, Visits: 3,347
You've made a type in the restore command. You have missed the ":" after the drive.
MOVE 'MyDBDW_log' TO 'E\MSSQL\Log\MyDBDW.ldf'

must be:
MOVE 'MyDBDW_log' TO 'E:\MSSQL\Log\MyDBDW.ldf'


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1466988
Posted Tuesday, June 25, 2013 7:34 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 5, 2016 6:33 AM
Points: 401, Visits: 779
HanShi (6/25/2013)
You've made a type in the restore command. You have missed the ":" after the drive.
MOVE 'MyDBDW_log' TO 'E\MSSQL\Log\MyDBDW.ldf'

must be:
MOVE 'MyDBDW_log' TO 'E:\MSSQL\Log\MyDBDW.ldf'


How often can we not see the wood for trees!!!
Post #1467143
Posted Tuesday, June 25, 2013 4:46 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 14, 2016 10:14 AM
Points: 5,016, Visits: 4,810
HanShi (6/25/2013)
You've made a type in the restore command. You have missed the ":" after the drive.
MOVE 'MyDBDW_log' TO 'E\MSSQL\Log\MyDBDW.ldf'

must be:
MOVE 'MyDBDW_log' TO 'E:\MSSQL\Log\MyDBDW.ldf'


I do not see a difference in the syntax?


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1467405
Posted Tuesday, June 25, 2013 6:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:42 AM
Points: 34,176, Visits: 18,325
You have

move to e\

It should be

move to e:\







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1467413
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse