Post reply

SQl Backup for 2005

  • March 7, 2006 at 2:53 pm

    #152808

    I get the following error. If I try to restore the database after moving the backup file from one server to another

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    ADDITIONAL INFORMATION:

    Too many backup devices specified for backup or restore; only 64 are allowed.

    RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)

     

    Kindest Regards,

    Amit Lohia

  • March 8, 2006 at 8:27 am

    #625424

    Amit,

    As Sql Server 2005 is completely new written software, Backups created with Microsoft SQL Server 2005 cannot be restored to an earlier version of Sql Server. i.e. No Backward compitibility. 

    I have confirmed this issue with Microsoft.

     

     

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • March 8, 2006 at 9:41 am

    #625456

    Thanks. I was incorrectly resorting the database on 2000 instance. I meant to restore on 2005.

    Kindest Regards,

    Amit Lohia

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

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