Attempting to do a data base recovery from backup and keep getting the following error: " The media set for database "isis" has 2 family members but only 1 are provided. All members must be provided."
I backed up the database in sql 2000 server and had to reinstall the sql 2000 server due to a system problem now the sql 2000 server us up and when i try to restore the database it gives me the above error. I hope some one out there can help.
Ray
You striped the backup over two backup files, and now you try to restore from only one of those
backups files. You need to find that other backup file before you can restore.
(This is similar to having two disks in a raid 0, take one of those to another machine and expect to
get to the data on that machine... :-) ).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raymond C Prys" <Raymond C Prys@.discussions.microsoft.com> wrote in message
news:E9DA9319-A918-4DF5-94BB-C1E0F9B7B2B9@.microsoft.com...
> Attempting to do a data base recovery from backup and keep getting the following error: " The
media set for database "isis" has 2 family members but only 1 are provided. All members must be
provided."
> I backed up the database in sql 2000 server and had to reinstall the sql 2000 server due to a
system problem now the sql 2000 server us up and when i try to restore the database it gives me the
above error. I hope some one out there can help.
> Ray
>
Showing posts with label isis. Show all posts
Showing posts with label isis. Show all posts
Thursday, March 22, 2012
database backup restore problem!
Attempting to do a data base recovery from backup and keep getting the following error: " The media set for database "isis" has 2 family members but only 1 are provided. All members must be provided."
I backed up the database in sql 2000 server and had to reinstall the sql 2000 server due to a system problem now the sql 2000 server us up and when i try to restore the database it gives me the above error. I hope some one out there can help.
RayYou striped the backup over two backup files, and now you try to restore from only one of those
backups files. You need to find that other backup file before you can restore.
(This is similar to having two disks in a raid 0, take one of those to another machine and expect to
get to the data on that machine... :-) ).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raymond C Prys" <Raymond C Prys@.discussions.microsoft.com> wrote in message
news:E9DA9319-A918-4DF5-94BB-C1E0F9B7B2B9@.microsoft.com...
> Attempting to do a data base recovery from backup and keep getting the following error: " The
media set for database "isis" has 2 family members but only 1 are provided. All members must be
provided."
> I backed up the database in sql 2000 server and had to reinstall the sql 2000 server due to a
system problem now the sql 2000 server us up and when i try to restore the database it gives me the
above error. I hope some one out there can help.
> Ray
>
I backed up the database in sql 2000 server and had to reinstall the sql 2000 server due to a system problem now the sql 2000 server us up and when i try to restore the database it gives me the above error. I hope some one out there can help.
RayYou striped the backup over two backup files, and now you try to restore from only one of those
backups files. You need to find that other backup file before you can restore.
(This is similar to having two disks in a raid 0, take one of those to another machine and expect to
get to the data on that machine... :-) ).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raymond C Prys" <Raymond C Prys@.discussions.microsoft.com> wrote in message
news:E9DA9319-A918-4DF5-94BB-C1E0F9B7B2B9@.microsoft.com...
> Attempting to do a data base recovery from backup and keep getting the following error: " The
media set for database "isis" has 2 family members but only 1 are provided. All members must be
provided."
> I backed up the database in sql 2000 server and had to reinstall the sql 2000 server due to a
system problem now the sql 2000 server us up and when i try to restore the database it gives me the
above error. I hope some one out there can help.
> Ray
>
database backup restore problem!
Attempting to do a data base recovery from backup and keep getting the follo
wing error: " The media set for database "isis" has 2 family members but on
ly 1 are provided. All members must be provided."
I backed up the database in sql 2000 server and had to reinstall the sql 200
0 server due to a system problem now the sql 2000 server us up and when i tr
y to restore the database it gives me the above error. I hope some one out
there can help.
RayYou striped the backup over two backup files, and now you try to restore fro
m only one of those
backups files. You need to find that other backup file before you can restor
e.
(This is similar to having two disks in a raid 0, take one of those to anoth
er machine and expect to
get to the data on that machine... :-) ).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raymond C Prys" <Raymond C Prys@.discussions.microsoft.com> wrote in message
news:E9DA9319-A918-4DF5-94BB-C1E0F9B7B2B9@.microsoft.com...
> Attempting to do a data base recovery from backup and keep getting the following e
rror: " The
media set for database "isis" has 2 family members but only 1 are provided.
All members must be
provided."
> I backed up the database in sql 2000 server and had to reinstall the sql 2000 serv
er due to a
system problem now the sql 2000 server us up and when i try to restore the d
atabase it gives me the
above error. I hope some one out there can help.
> Ray
>
wing error: " The media set for database "isis" has 2 family members but on
ly 1 are provided. All members must be provided."
I backed up the database in sql 2000 server and had to reinstall the sql 200
0 server due to a system problem now the sql 2000 server us up and when i tr
y to restore the database it gives me the above error. I hope some one out
there can help.
RayYou striped the backup over two backup files, and now you try to restore fro
m only one of those
backups files. You need to find that other backup file before you can restor
e.
(This is similar to having two disks in a raid 0, take one of those to anoth
er machine and expect to
get to the data on that machine... :-) ).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raymond C Prys" <Raymond C Prys@.discussions.microsoft.com> wrote in message
news:E9DA9319-A918-4DF5-94BB-C1E0F9B7B2B9@.microsoft.com...
> Attempting to do a data base recovery from backup and keep getting the following e
rror: " The
media set for database "isis" has 2 family members but only 1 are provided.
All members must be
provided."
> I backed up the database in sql 2000 server and had to reinstall the sql 2000 serv
er due to a
system problem now the sql 2000 server us up and when i try to restore the d
atabase it gives me the
above error. I hope some one out there can help.
> Ray
>
Subscribe to:
Posts (Atom)