🚀 go-pugleaf

Richard,

Unless I'm mistaken, the full text of the error message suggests you refer
to the SQL Server error log for details. What does the SQL Server error log
say?

Make sure that the account that SQL Server is running under has operating
system authorization to the network device. For example, if you are running
SQL Server under the LocalSystem account, then SQL Server only has rights to
the local drives.

----------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Richard Gilbert" <bixgomez@earthlink.net> wrote in message
news:zvpa6.2412$9D5.274782@newsread1.prod.itd.earthlink.net...
> Dear Friends,
>
> I am having some trouble trying to create a network dump device for
backups!
> I have no trouble creating a local device, such as "D:\backup\backup.dat,"
> but when I try to create a device on another machine on my network, I the
> following error when I try to backup: "Cannot open backup device ...
Device
> error or device off-line."
>
> Here is the script I am using to create the device:
>
> sp_addumpdevice 'disk',
>  'NetworkBackupTest3',
>  '\\Utilities2\E\backuptest3\NETBACKUP.DAT'
>
> Can anyone help?
>
> Thanks,
> Richard
>
>
>
>