Posted by Dan Guzman on 05/21/05 16:39

A restore from a UNC path should work. What error is recorded in the SQL
Server error log? This may provide additional details on the cause of the
error.

As Mike indicated, the SQL Server service account on serverC needs
permissions to the serverB share:

RESTORE DATABASE MyDatabase
FROM DISK = '\\serverB\pharmacy\pharmacy_db_200505210330.BAK'

You might also try to access the share via xp_cmdshell for debugging:

EXEC master..xp_cmdshell 'DIR \\serverB\pharmacy'

--
Hope this helps.

Dan Guzman
SQL Server MVP

<Tommy.Vincent@gmail.com> wrote in message
news:1116679001.658121.20350@g44g2000cwa.googlegroups.com...
> hi,
>
> I tried using UNC paths ,but still its not working.
>
> I am not clear with your second point of(SQL Server Service Accounts
> need to be domain users, and have rights on the share)
>
> my SQL Server Service Accounts are in domain users and have rights on
> share.
>
> Please can u be more specific about this and tell me how should i check
> this
>
> and do this.
>
> Thanks in advance
>
> T.V
>
>
>
>
>
> Mike Epprecht (SQL MVP) wrote:
>> Hi
>>
>> Don't use Mapped drives, use UNC paths.
>>
>> You SQL Server Service Accounts need to be domain users, and have
> rights on
>> the share.
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@epprecht.net
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> <Tommy.Vincent@gmail.com> wrote in message
>> news:1116674186.599082.158470@g43g2000cwa.googlegroups.com...
>> > Hi,
>> >
>> > its newbie question.
>> >
>> > I have one production server(A) ,one backup server(B),additional
>> > server(C).
>> >
>> > my database backup are moved from A to C in regular basis.
>> >
>> > My problem is that when ever I have to restore my database in
> Backup
>> > Server i.e B,
>> >
>> > I have to first copy that particular Backup File on to my Backup
> Server
>> > from C
>> >
>> > then i have to perform my restoration process.
>> >
>> > Even if I mapped the drive in which my bakup file is lying ,I am
>> > not able to see that drive in SQL Entriprise Manager and when i am
>> > restoring through Query Analyzer
>> > it shows the following error -
>> >
>> > Server: Msg 3201, Level 16, State 2, Line 1
>> > Cannot open backup device
> 'G:\pharmacy\pharmacy_db_200505210330.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 DATABASE is terminating abnormally.
>> >
>> > What i think is it a waste a time ,first copy the bak file in local
>> > drive and perform the restoration process.
>> >
>> > SO please can any one guide me how should i do the network
> restoration
>> > if possible or put me to right path for doing it so.
>> >
>> > I am using SQL SERVER 2000,OS WINDOWS 2000 Adv SERVER.
>> >
>> > cheers
>> >
>> > T.V
>> >
>

[Back to original message]