469,299 Members | 2,073 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

Network Restoration Of Database

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

Jul 23 '05 #1
3 2234
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: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<To***********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.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

Jul 23 '05 #2
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: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<To***********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.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


Jul 23 '05 #3
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

<To***********@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.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: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<To***********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.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
>

Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Adam Smith | last post: by
1 post views Thread by Tommy.Vincent | last post: by
reply views Thread by aashiss03 | last post: by
reply views Thread by Now You Know | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.