MS SQL Server - RESTORE HEADERONLY

Author

RESTORE HEADERONLY

SalamElias

2006-10-24, 6:30 pm

Hi, can I make a restore headeronly from a share on the network :as follows :
RESTORE HEADERONLY FROM DISK = '\\backup1\e$\custom
er1\Customer.bak'.

When I run it on the server itself it works fine, however when I run it from
my desktop I get the following error :

********************
****
Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device '\\backup1\e$\custom
er1\Customer.bak'.
Device error or device off-line. See the SQL Server error log for more
details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
********************
******

Of course before launching the TSQL I do a ne"t use ..../IPC$ which
terminates correctly on the backup machine

Hari Prasad

2006-10-24, 6:30 pm

Hi,

Are you doing the NET USE command inside the query analyzer. If yes, then it
should work.

Thanks
hari
SQL Server MVP

"SalamElias" <eliassal@online.nospam> wrote in message
news:82E9AE46-C1DF-44D1-BE3C- 2E89FF0097F8@microso
ft.com...
> Hi, can I make a restore headeronly from a share on the network :as
> follows :
> RESTORE HEADERONLY FROM DISK = '\\backup1\e$\custom
er1\Customer.bak'.
>
> When I run it on the server itself it works fine, however when I run it
> from
> my desktop I get the following error :
>
> ********************
****
> Server: Msg 3201, Level 16, State 2, Line 1
> Cannot open backup device '\\backup1\e$\custom
er1\Customer.bak'.
> Device error or device off-line. See the SQL Server error log for more
> details.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE FILELIST is terminating abnormally.
> ********************
******
>
> Of course before launching the TSQL I do a ne"t use ..../IPC$ which
> terminates correctly on the backup machine

Linchi Shea

2006-10-24, 6:30 pm

> Of course before launching the TSQL I do a ne"t use ..../IPC$ which

> terminates correctly on the backup machine

That may be the problem. This only authenticates you from where you run the
SQL statement. You need to make sure that the SQL Server service can access
the share. You cn run net use prior to RESTORE in EXEC master..xp_cmdshell.

Linchi

"SalamElias" wrote:

> Hi, can I make a restore headeronly from a share on the network :as follows :
> RESTORE HEADERONLY FROM DISK = '\\backup1\e$\custom
er1\Customer.bak'.
>
> When I run it on the server itself it works fine, however when I run it from
> my desktop I get the following error :
>
> ********************
****
> Server: Msg 3201, Level 16, State 2, Line 1
> Cannot open backup device '\\backup1\e$\custom
er1\Customer.bak'.
> Device error or device off-line. See the SQL Server error log for more
> details.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE FILELIST is terminating abnormally.
> ********************
******
>
> Of course before launching the TSQL I do a ne"t use ..../IPC$ which
> terminates correctly on the backup machine

SalamElias

2006-10-24, 6:30 pm

Thanks, do you mean using cmdshell, go, the issue the restore statement

"Hari Prasad" wrote:

> Hi,
>
> Are you doing the NET USE command inside the query analyzer. If yes, then it
> should work.
>
> Thanks
> hari
> SQL Server MVP
>
> "SalamElias" <eliassal@online.nospam> wrote in message
> news:82E9AE46-C1DF-44D1-BE3C- 2E89FF0097F8@microso
ft.com...
>
>
>

Charles Wang[MSFT]

2006-10-24, 6:31 pm

Hi,
Please check if the client windows logon account is a domain user account
and if the user has full permission on your backup device.

Please note that if the user is not a domain account, trusted connection
can't be established between two computers.

Sincerely,
Charles Wang
Microsoft Community Support

Sponsored Links