first make a dump device that points to your network drive
For example, from Query Analizer
sp_adddumpdevice 'disk', '<mydumpdev>','\\server\C$\sqldumps\sqldump.bak'
Then

Backup database <mydb> to <mydumpdev>

Also read the books on line, they are very helpful.

Cheers
Ken





-----Original Message-----
From: Phil Shuttleworth [mailto:Phil.[Email Address Removed] Tuesday, September 03, 2002 5:11 AM
To: LazyDBA.com Discussion
Subject: SQL 7.0 Database Backups


Hallo all,

We have a problem concerning SQL Backup on one of our databases not under
our control. This database has not been backed up for some time. I need to
back the database up before I shrink it down and remove the inactive entries
to the transaction log. Because the database has not been backed up for
such a long time, there is not enough room to perform the backup in
Enterprise Manager on its own server drive before reducing the log.

Does anyone know if it is possible within Enterprise Manager to perform a
backup to another drive via the network? When we try to do this, we get a
message that the path cannot be verified, and the backup will not take
place.

If this is possible, how does it work?

Phil Shuttleworth

DBA, IT Services
University of Central England, BIRMINGHAM B42 2SU, UK
Tel: +44(0)121 331 5664 Fax: +44(0)121 356 2875
E-mail: Phil.[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page