Sign in
Microsoft.com
 
SQL Server TechCenter
 
 
 
SQL Server TechCenter > SQL Server Forums > SQL Server Disaster Recovery and Availability > How to restore from SQL dmp file
Ask a questionAsk a question
Search Forums:
 

QuestionHow to restore from SQL dmp file

  • Wednesday, October 28, 2009 5:36 AMscluie27 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Has Code
    Sign In to Vote
    0
    Sign In to Vote
    Hi,
We got SQL 2000 Server Standard running on Windows 2003 Server Standard 
edition. Our server crashed and we have an online (iBackup) backup of our SQL 
database on a dmp file. 

We reinstalled Win Server 2003 SE w/ SQL 2000 Server SE.  We tired restoring 
via the iBackup interface and keep getting the error below.

Microsoft][ODBC SQL Server Driver][SQL Server]The file on device 
'[Stratadial]' is not a valid Microsoft Tape Format backup set. 
 
Unable to restore sql database 
 
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is 
terminating abnormally.

My question is this, is there another way to restore the SQL database from 
the dmp file beside using iBackup.  What is the error message telling me? There must be a very easy process to rstore from the dmp file within enterprise manager.
    
Your help would be much appricated. 

Thank you,
Steve
     

All Replies

  • Wednesday, October 28, 2009 6:47 AMLekss Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Hi Steve,

    I think this is the error message related to corrupted backup file,

    -- There must be a very easy process to rstore from the dmp file within enterprise manager

    I dont think so , the backup taken through a third party tool cannot be processed / restored by SQL server using its native restore method.
    At least if sql server is able to read this backup file , then it should respond for RESTORE VERIFYONLY (Verifies the backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable. However, it does not attempt to verify the structure of the data contained in the backup volumes)

    Thanks, Leks
     
  • Wednesday, October 28, 2009 2:59 PMSQLCraftsmanMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    The problem is that SQL Server only understands its own backup (.bak) files.  The backup created by your iBackup software is only readable by that software.  The .dmp is proprietary to iBackup and cannot be read by SQL Server natively.

    I know this is a bit late, but this is precisely why you test your recovery process.

    You need to install iBackup and attempt to restore through that software.
    Geoff N. Hiten Principal Consultant Microsoft SQL Server MVP