-
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?
-
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'
-
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?
-
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.
-
Thank you Rawhide, SQLteam rocks!
-
You're welcome ... but who's SQLteam?
-
never mind. I found this forum at www.sqlteam.com. I thought this forum belongs to them, I guess not.
-
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
-
Forum Rules
|
|