|
|
Posted by Mike Epprecht \(SQL MVP\) on 05/21/05 14:58
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
>
Navigation:
[Reply to this message]
|