Friday, March 9, 2012

restore of msdb database

I try to restore the msdb database. i get the error "the media set for
database msdb has 2 family members byt only 1 are provided. all members must
be provided. restore database is terminating abnormally. i have followed the
procedure to restore msdb.The error message states that when you performed the backup, you striped it over two backup devices.
This can be verified using RESTORE LABELONLY. You need to find both in order to do restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joia" <joia@.discussions.microsoft.com> wrote in message
news:F2A56209-B3A6-4DB7-BFAB-2247F98A9C87@.microsoft.com...
>I try to restore the msdb database. i get the error "the media set for
> database msdb has 2 family members byt only 1 are provided. all members must
> be provided. restore database is terminating abnormally. i have followed the
> procedure to restore msdb.

No comments:

Post a Comment