Post reply

Restore database failure

  • January 22, 2010 at 9:17 pm

    #218507

    I was trying to restore a SQL server 2005 database on SQL server 2008 and got below error message.

    The database was backed up on a server running version 9.00.1187. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server

    This backup file is from an ebook for SQL Server 2005 reporting services. The entire book is based on this backup file. Is there any way I could restore the database on SQL server 2008 using this backup file?

    M&M

  • January 22, 2010 at 10:05 pm

    #1107685

    weird, I've always been told that a backup from a previous version(2000,2005) can be restored on 2008.

    my google-fu found this link at MS, which says you can get that error if the backup was made with 2005 and a version prior to SP2:

    http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169

    download 2005 express and restore it, maybe? then with service packs applied you could back it up again and restore it on your 2008;

    also check the books web site, they might have a better download for you to use.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 23, 2010 at 1:11 am

    #1107713

    I suspect it has to do with that db coming from a beta version of SQL Server 2005. (RTM was 1399, hence 1187 must have been one of the late CTPs)

    Install a SQL 2005 database, apply SP2 or 3, then backup and restore on 2008.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 25, 2010 at 9:46 pm

    #1108478

    Dear All,

    Thanks for your help. I wrote to the author of this book and he asked me to download the source code from the book he had written for SQL Server 2008 reporting services 🙂

    M&M

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

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