Restore Database

When I try to restore my database receive the message:

"The media set for database 'MyDB' has 2 family members, but only 1 are provided. All members must be provided."

I don't find the other dump device.

Do I can restore anyway??

thanks,

Ericson.I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?

Any ideas?|||Originally posted by acg_ray
I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?

Any ideas?

I have no succes to restore my database.
I has create the database again e loses the data.|||One of my customers reported the same problem that you guys were having. I found in his case that he had spanned his backup across multiple files when he made it.

So, in the Database Backup Destination box, he had multiple entries before backing up. Then when he went to restore the database to another machine, he was unaware that he should have had multiple files. This restore file was coded to tell Sql Server that it was only one part of the backup.

In his case, I had him go back to the server and create only one backup file.|||Are you using tape backup? It may be that your database backup run across two tapes and it's looking for another backup media.

restore

Hi,
When I run the sql:
RESTORE DATABASE mydb
FROM DISK='\\myserver\mydb.bak'
Got error:
Msg 3201, Level 16, State 2, XXXDELL, Line 2
Cannot open backup device
\\myserver\mydb.bak' . Device
error or device off-line. See the SQL Server error log for more
details.
Msg 3013, Level 16, State 1, Server XXXDELL, Line 2
RESTORE DATABASE is terminating abnormally.
the path is right.
is it restore statment support UNC? how to fix it? Thanks.Make sure that the SQL Server service account has permissions on the share.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"js" <js@.someone@.hotmail.com> wrote in message news:%23nqb0uusFHA.524@.TK2MSFTNGP12.phx.gbl.
.
> Hi,
> When I run the sql:
> RESTORE DATABASE mydb
> FROM DISK='\\myserver\mydb.bak'
> Got error:
> Msg 3201, Level 16, State 2, XXXDELL, Line 2
> Cannot open backup device
> \\myserver\mydb.bak' . Device
> error or device off-line. See the SQL Server error log for more
> details.
> Msg 3013, Level 16, State 1, Server XXXDELL, Line 2
> RESTORE DATABASE is terminating abnormally.
> the path is right.
> is it restore statment support UNC? how to fix it? Thanks.
>
>|||Check that the sql agent services account has read permission to the unc
folder.
AMB
"js" wrote:

> Hi,
> When I run the sql:
> RESTORE DATABASE mydb
> FROM DISK='\\myserver\mydb.bak'
> Got error:
> Msg 3201, Level 16, State 2, XXXDELL, Line 2
> Cannot open backup device
> \\myserver\mydb.bak' . Device
> error or device off-line. See the SQL Server error log for more
> details.
> Msg 3013, Level 16, State 1, Server XXXDELL, Line 2
> RESTORE DATABASE is terminating abnormally.
> the path is right.
> is it restore statment support UNC? how to fix it? Thanks.
>
>
>|||Hi
RESTORE DATABASE mydb
FROM DISK='\\myserver\mydb.bak'
is not valid.
RESTORE DATABASE mydb
FROM DISK='\\myserver\sharename\mydb.bak'
would be right and make sure the service account has rights to the share.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"js" wrote:

> Hi,
> When I run the sql:
> RESTORE DATABASE mydb
> FROM DISK='\\myserver\mydb.bak'
> Got error:
> Msg 3201, Level 16, State 2, XXXDELL, Line 2
> Cannot open backup device
> \\myserver\mydb.bak' . Device
> error or device off-line. See the SQL Server error log for more
> details.
> Msg 3013, Level 16, State 1, Server XXXDELL, Line 2
> RESTORE DATABASE is terminating abnormally.
> the path is right.
> is it restore statment support UNC? how to fix it? Thanks.
>
>
>|||"Alejandro Mesa" wrote in message
news:73490624-C538-4CC3-9C9A-B40710E0E0B1@.microsoft.com...
> Check that the sql agent services account has read permission to the unc
> folder.
>
Thanks for the help.
is it sql agent services account or sql server account?|||SQL Server service account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"js" <js@.someone@.hotmail.com> wrote in message news:eDlbE%23usFHA.3852@.TK2MSFTNGP15.phx.gbl
..
> "Alejandro Mesa" wrote in message news:73490624-C538-4CC3-9C9A-B40710E0E0
B1@.microsoft.com...
> Thanks for the help.
> is it sql agent services account or sql server account?
>|||sql agent services account
AMB
"js" wrote:

> "Alejandro Mesa" wrote in message
> news:73490624-C538-4CC3-9C9A-B40710E0E0B1@.microsoft.com...
> Thanks for the help.
> is it sql agent services account or sql server account?
>
>|||Sorry for the wrong info. In order to backup or restore from a shared folder
,
the sql server service should use a domain account and this account should
have enough permission to read and / or write to it.
AMB
"Alejandro Mesa" wrote:
> sql agent services account
>
> AMB
> "js" wrote:
>