Can 2005 be backed up onto a 2000 machine?

  • Can you create a backup from 2005 SQL Server and restore it onto a 2000 SQL Server? I have 2000 and am trying to test some errors from anotehr persons 2005 system.

  • Hi TScott,

         No. The database structures are different. You can not restore a Sql 2005 database on Sql 2000.

     

    If you have additional questions about this please reply to me. Unfortunately, I do not get to read the forums every day.

     

     

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • When it was in Beta the was a utility to convert 2005 to 2000. Does this still exist, or was it dropped. I know that there was a 2000-2005 support wizard also, and its still there.

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

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