Network Restoration Of Database

**Mike Epprecht \(SQL MVP\)** · Jul 23 '05, 09:07 AM

Re: Network Restoration Of Database

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.n et

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.goo glegroups.com.. .[color=blue]
> Hi,
>
> its newbie question.
>
> I have one production server(A) ,one backup server(B),addit ional
> 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\ph armacy_db_20050 5210330.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
>[/color]

**Tommy.Vincent@gmail.com** · Jul 23 '05, 09:07 AM

Re: Network Restoration Of Database

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:[color=blue]
> Hi
>
> Don't use Mapped drives, use UNC paths.
>
> You SQL Server Service Accounts need to be domain users, and have[/color]
rights on[color=blue]
> the share.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.n et
>
> 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.goo glegroups.com.. .[color=green]
> > Hi,
> >
> > its newbie question.
> >
> > I have one production server(A) ,one backup server(B),addit ional
> > 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[/color][/color]
Backup[color=blue][color=green]
> > Server i.e B,
> >
> > I have to first copy that particular Backup File on to my Backup[/color][/color]
Server[color=blue][color=green]
> > 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[/color][/color]
'G:\pharmacy\ph armacy_db_20050 5210330.BAK'.[color=blue][color=green]
> > Device error or device off-line. See the SQL Server error log for[/color][/color]
more[color=blue][color=green]
> > 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[/color][/color]
restoration[color=blue][color=green]
> > 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
> >[/color][/color]

**Dan Guzman** · Jul 23 '05, 09:07 AM

Re: Network Restoration Of Database

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\phar macy\pharmacy_d b_200505210330. BAK'

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

EXEC master..xp_cmds hell 'DIR \\serverB\pharm acy'

--
Hope this helps.

Dan Guzman
SQL Server MVP

<Tommy.Vincent@ gmail.com> wrote in message
news:1116679001 .658121.20350@g 44g2000cwa.goog legroups.com...[color=blue]
> 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:[color=green]
>> Hi
>>
>> Don't use Mapped drives, use UNC paths.
>>
>> You SQL Server Service Accounts need to be domain users, and have[/color]
> rights on[color=green]
>> the share.
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@epprecht.n et
>>
>> 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.goo glegroups.com.. .[color=darkred]
>> > Hi,
>> >
>> > its newbie question.
>> >
>> > I have one production server(A) ,one backup server(B),addit ional
>> > 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[/color][/color]
> Backup[color=green][color=darkred]
>> > Server i.e B,
>> >
>> > I have to first copy that particular Backup File on to my Backup[/color][/color]
> Server[color=green][color=darkred]
>> > 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[/color][/color]
> 'G:\pharmacy\ph armacy_db_20050 5210330.BAK'.[color=green][color=darkred]
>> > Device error or device off-line. See the SQL Server error log for[/color][/color]
> more[color=green][color=darkred]
>> > 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[/color][/color]
> restoration[color=green][color=darkred]
>> > 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
>> >[/color][/color]
>[/color]

Network Restoration Of Database

Network Restoration Of Database

Comment

Comment

Comment