none
Restore sql server 2000 backup on sql server 2008

    Question

  • Based on the books online I am not allowed to upgrade a database at sql server 2000 to sql server 2008. But I tried restoring the sql server 2000 backup on the Katmai release available and it works. It initially did have the database in sql server 2000 compatibility mode but later I was even able to change the mode to be 2008 compatible.

    So what is it am I allowed to do it or not?

    Wednesday, July 18, 2007 6:44 PM

Answers

  •  

    You can upgrade a SQL Server 2000 database directly to SQL Server 2008.

    This is fully supported.

    Not all of the upgrade setup code is in yet, so there are limitations on what upgrade scenarios are supported at this point.  (Actually, I don't believe any instance upgrade is supported as of the July CTP.)

     

    If you can give me a pointer to the BOL section you read, I'll make sure it is correct, or get it corrected.

     

    Thanks

    Monday, August 20, 2007 4:54 AM

All replies

  • I think it means that you cannot upgrade a SQL Server 2000 instance to SQL Server 2008.

    The database itself should be compatible (one way of course).  What exactly is stated in the BOL? 

     

    WesleyB

    Visit my SQL Server weblog @ http://dis4ea.blogspot.com

    Thursday, July 19, 2007 6:57 PM
  •  

    You can upgrade a SQL Server 2000 database directly to SQL Server 2008.

    This is fully supported.

    Not all of the upgrade setup code is in yet, so there are limitations on what upgrade scenarios are supported at this point.  (Actually, I don't believe any instance upgrade is supported as of the July CTP.)

     

    If you can give me a pointer to the BOL section you read, I'll make sure it is correct, or get it corrected.

     

    Thanks

    Monday, August 20, 2007 4:54 AM
  •  

    You can upgrade a SQL Server 2000 database directly to SQL Server 2008.

    This is fully supported.

    Not all of the upgrade setup code is in yet, so there are limitations on what upgrade scenarios are supported at this point.  (Actually, I don't believe any instance upgrade is supported as of the July CTP.)

     

    If you can give me a pointer to the BOL section you read, I'll make sure it is correct, or get it corrected.

     

    Thanks


    Can you please specify how this works or point me in the direction of a webpage that does? I'm at a serious loggerhead as to how to get this done in a workplace situation. I had a version of SQL Server upgraded to 2008 without warning, and canot restore earlier versions of SQL Server.

    (And advice as to how to restore other vrsions such as , say, 2005, would also be greatly appreciated.)

     



    Friday, July 29, 2011 4:58 AM
  • Note that once you upgrade the database from SQL Server 2000 to 2008, you cannot move it back to 2000.  So make sure you have a backup of it left on 2000, just in case.

    Rgds,

    Dave.

    Wednesday, August 03, 2011 11:17 AM