Issue with Backup Device for network backup

by the3factory 5/3/2008 12:11:00 AM

SQL Server Database Engine Issue with Backup Device for network backup
Question:

Server: MS SQL Server 2000 (8.00.2039)

Command 1:

Backup database Test
to Disk = '\\servername\sharename\filename.ext'

Result: Backup is successfully taken on network share
----------------------------------------------------------------------------------
Command 2:

USE master
EXEC sp_addumpdevice 'disk', 'networkdevice','\\servername\sharename\filename.ext'
go
Backup Database Test
to Disk = 'networkdevice'

Result: Backup command succeeds but instead of network drive, backup is taken on default backup folder of local machine.
----------------------------------------------------------------------------------

Both the commands are fired from same server. Any idea why the backups are taken on local server and not on network path?

Thanks,
Santy

MS SQL Server DBA Answer1:

Try this:

Code SnippetAnswer2:
How do I access your Code Snippet?

Answer3:
Rao,

You can just copy the code inside the code snippet and use it. What is the issue you face ?

- Deepak

Deepak | Mark the answers if it helps to solve your problem | Answer4:

We are facing the same issue to take backup accross network. (The code needs to be incorprated in our program)

One should not include the ":" while accessing network paths? and only specify "\" and the drive letter ?

I'm new to your forum and don't know how to copy / retrieve the code snippet, if any. So please let me know how to.

Answer5:

Hi SQLUSA,