Tuesday, February 21, 2012

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:
>

No comments:

Post a Comment