Post reply

Error Restoring Database

  • June 24, 2013 at 6:09 pm

    #295063

    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/

  • June 24, 2013 at 6:16 pm

    #1626959

    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

  • June 24, 2013 at 6:35 pm

    #1626962

    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[/url]

    How to Post Best Practices[/url]

  • June 24, 2013 at 6:45 pm

    #1626963

    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/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply