Results 1 to 3 of 3

Thread: Error:The backup set holds a backup of a database other than the existing database

  1. #1
    Join Date
    Jun 2007
    Posts
    11

    Error:The backup set holds a backup of a database other than the existing database

    Hi 2 all

    i have a backup file of database named "users" backedup as c:/users.bak
    that was created with SQL Server 2005 Express Edition

    Know I am using SQL Server 2005 enterprise edition
    I made a database with name users and then used
    tasks>restore>database and tried to restore c:/users.bak

    but got error: The backup set holds a backup of a database other than the existing 'users' database

    The backj up is too neccesary
    play help to recover it


    OTHER additional Information:
    1.when i try to restore c:/users.bak
    the attibutes are:
    users-完整 数据库 备份 Database Full ZXZCOM\SQLEXPRESS users 1 66000000036500037 66000000038300001 66000000036500037 66000000036500037 3/1/2007 8:04:57 AM 3/1/2007 8:04:58 AM 1520128 ZXZCOM\Administrator 3/11/2007 8:04:57 AM

    2. if i take backup of empty database users(which is to be restored) in 2005 enterprise version
    the attributes are:

    users-完整 数据库 备份 Full Database Backup Database Full MOHIT users 1 35000000032300040 35000000034000001 35000000032300040 35000000032300040 7/18/2007 5:18:04 PM 7/18/2007 5:18:05 PM 1395200 HGTECH0\GSR


    Thanks
    Last edited by gsriar; 07-18-2007 at 08:07 AM. Reason: clearity of subject

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Use RESTORE command WITH REPLACE option, or drop users database from Enterprise edition server and run the restore wizard.

  3. #3
    Join Date
    Jun 2007
    Posts
    11
    thank skhanal

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •