Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Restoring Database Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 6:09 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:06 PM
Points: 4,253, Visits: 4,295
I execute the following:

FROM DISK =  'I:\Backups\CYP_DW\Full\MyDBDW\MyDBDW_backup_2013_06_24_163430_3276765.bak'
WITH RECOVERY,
MOVE 'MyDBStaging' TO 'E:\MSSQL\Data\MyDBStaging.mdf',
MOVE 'MyDBStaging_log' TO 'E:\MSSQL\Log\MyDBStaging.ldf',
REPLACE

RESTORE DATABASE MyDBStaging


I get the following error. I'm not trying to create the DB on but on E?

Msg 3257, Level 16, State 1, Line 2
There is insufficient free space on disk volume 'D:\' to create the database. The database requires 216796037120 additional free bytes, while only 160890318848 bytes are available.
Msg 3119, Level 16, State 4, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
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 #1466954
Posted Monday, June 24, 2013 6:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 11:04 AM
Points: 86, Visits: 378
May be this database point to D:\ drive.
1. please look in to data files first.
2. if its point to D:\ change to E:\ drive.
then run the restore script
Post #1466956
Posted Monday, June 24, 2013 6:35 PM


SSC-Addicted

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

Group: General Forum Members
Last Login: Monday, December 15, 2014 7:38 AM
Points: 413, Visits: 323
Any chance there are more files than just the primary data and log file?

Try: RESTORE FILELISTONLY FROM DISK = 'C:\Test\backuptest.bak'


Mike

How to Post Performance Problems

How to Post Best Practices
Post #1466959
Posted Monday, June 24, 2013 6:45 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:06 PM
Points: 4,253, Visits: 4,295
I got it to work:

RESTORE DATABASE MyDBStaging
FROM DISK = 'I:\Backups\CYP_DW\Full\MyDBDW\MyDBDW_backup_2013_06_24_163430_3276765.bak'
--WITH RECOVERY
WITH MOVE 'MyDBStaging' TO 'E:\MSSQL\Data\MyDBStaging.mdf',
MOVE 'MyDBStaging_log' TO 'E:\MSSQL\Log\MyDBStaging.ldf',
REPLACE


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 #1466960
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse