I execute the following:
FROM DISK = 'I:\Backups\CYP_DW\Full\MyDBDW\MyDBDW_backup_2013_06_24_163430_3276765.bak'
MOVE 'MyDBStaging' TO 'E:\MSSQL\Data\MyDBStaging.mdf',
MOVE 'MyDBStaging_log' TO 'E:\MSSQL\Log\MyDBStaging.ldf',
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/