Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Backup to netwerkdrive
0 views
Skip to first unread message
Daedalus
Nov 17, 2009, 12:22:32 PM11/17/09
to
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
Plamen Ratchev
Nov 17, 2009, 12:55:45 PM11/17/09
to
It is best to type manually the UNC path to the network share, like
\\server\share\db_backup.bak
\\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
dmmaxwell
Nov 20, 2009, 11:07:14 AM11/20/09
to
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.
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.
Message has been deleted
0 new messages