Network Backup -- sql server misc

Adnan
7/25/2003 1:11:03 PM

I want to backup up one of my Database running on SQL Server 2000 on to
another machine on the network. I already have a Database Maintenace plan
set up which backs up the database on the same box. But now I want to back
it up on a different machine as a disaster recovery measure. Under the
Enterprise Managerin SQL Server I only have the option to back it up on
a device and cant seem to do it over the Network. Anyone has any ideas on
how to do this without using a 3rd party software?

I was told to just specify the UNC path (\\servername\share for example) and
make sure the
account used by the sql server service has privileges on that network share
but when I try to do that the Database Maintanence plan chucks back with an
error "The complete database backup directory"\\servername\share" is
invalid. Are you sure this is what you want?"

I havent actually tried clicking YES to that as yet....is it really an error
message?

Adnan

John Bell
7/27/2003 8:15:58 PM

Hi

At a guess \\servername\share is a directory and not a backup device/file.
Therefore you are not specifying a proper physical device. Try something
like \\servername\share\Backup.bak

John

[quoted text, click to view]

sql server misc : Network Backup