Results 1 to 8 of 8

Thread: ms sql error during restore

  1. #1
    Join Date
    Dec 2004
    Posts
    4

    ms sql error during restore

    I have MSSQL 7.0 Database backedup using the wizard, and trying to restore the database on MSSQL2000. I get an error which I've never seen before.

    It says:

    Microsoft SQL-DMO (ODBC SQLState:42000)
    The media set for database 'Runtime' has 2 family members but only 1 are provided. All members must be provided.

    RESTORE DATABASE is terminating abnormally

    anyone know what would cause that?

  2. #2
    Join Date
    Feb 2003
    Posts
    1,048
    The error means the backup was done using more than one
    device or backup file and you are trying to restore using
    just one. You need to provide all the backup devices, files
    in your restore command, e.g.:
    RESTORE DATABASE YourDatabase
    FROM
    DISK = 'C:\YourDB1.BAK', DISK = 'C:\YourDB2.BAK'

  3. #3
    Join Date
    Dec 2004
    Posts
    4
    Thanks Rawhide,

    I deleted the previous backups and re-create a new one. When I do restore, now I got a different message.

    The backup set holds a back up of a database other than the existing 'RunTime' database.

    Is is mean the new back up I made the second time was corrupted?

  4. #4
    Join Date
    Feb 2003
    Posts
    1,048
    Now that you are restoring over an existing database, you need to use WITH REPLACE statement at the end of your restore Statement.

    RESTORE DATABASE YourDatabase
    FROM DISK = 'C:\YourDB1.BAK'
    WITH REPLACE

    This will delete the existing database by that name and replace it with the new one.

  5. #5
    Join Date
    Dec 2004
    Posts
    4
    Thank you Rawhide, SQLteam rocks!

  6. #6
    Join Date
    Feb 2003
    Posts
    1,048
    You're welcome ... but who's SQLteam?

  7. #7
    Join Date
    Dec 2004
    Posts
    4
    never mind. I found this forum at www.sqlteam.com. I thought this forum belongs to them, I guess not.

  8. #8
    Join Date
    Feb 2003
    Posts
    1,048
    Never heard of sqlteam.com before. I'll check them out. I don't know if the two sites are afilliated in any way or not.

Posting Permissions

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