Hi

I'm running SQL-server 2005, and when I try to backup, I don't see any
networkdrive, only C: is available.
Any suggestions ?

Tanx in advance !

D

It is best to type manually the UNC path to the network share, like
\\server\share\db_backup.bak

Also, make SQL Server is running under an account that has permissions to that share (normally a domain account).

--
Plamen Ratchev
http://www.SQLStudio.com

If you have the disk space, backup local, then have a process to copy
the file to the remote location. In most cases, this will be a lot
faster, and you don't have to grant permissions to the SQL Agent
account for the remote share if you don't want to. YMMV.

-D.

When doing a backup, the account that the sql service is running under
will need permission to write to the remote share
(run services.msc and look for the sql server service. Then look in
properties, Log On to see what account sql is running under)
You can run the sql service using an Active Directory or Windows user
account, and then ensure that the account has permissions to write to
the network drive