Post reply

facing this error when restoring database from..

  • July 22, 2006 at 6:43 am

    #113103

    dear

    I am facing error as given below when i am trying to restore database from sql server 2000 -> sql server 2005.

    i have backed up my database from sql server 2000 and i want this database in sql server 2005

    error

    System.data.sqlclient.sqlerror:

    The backup set holds a backup of a database other than the existing  'today' database.

    (Microsoft.SqlServer.smo)

    I created new database as today.eventhough it displays same error.

    please help me out

    waiting for reply.

    regards,

    ASIF

  • July 22, 2006 at 1:54 pm

    #650930

    I have done several restores of a SQL 2000 database to SQL 2005 and have never had any trouble.

    You might check to make sure you don't have the compatibility mode of your 2000 database set to anything before 2000?

    I've only restored from scratch, or dropped and then restored a database.  I've never tried restoring over an existing database on 2005 from a 2000 backup.

     

    The Redneck DBA

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

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