locked
Restoring a Database Error - Restore failed for server RRS feed

  • Question

  • Restore failed for server

    Please help!


    Eshmat

    Thursday, October 2, 2014 7:50 AM

Answers

  • Hello,

    Seems the backup file is corrupt, check it with a RESTORE VERIFYONLY (Transact-SQL) command.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Charlie Liao Monday, October 6, 2014 11:19 AM
    • Marked as answer by Charlie Liao Sunday, October 12, 2014 8:32 AM
    Thursday, October 2, 2014 7:52 AM
  • In SSMS open a new query window and run the command, should look like

    RESTORE VERIFYONLY
    FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup\AdventureWorks2008.bak'


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Charlie Liao Monday, October 6, 2014 11:19 AM
    • Marked as answer by Charlie Liao Sunday, October 12, 2014 8:32 AM
    Thursday, October 2, 2014 8:04 AM

All replies