Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Backup to netwerkdrive
16 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.
BrianR
Nov 23, 2009, 6:51:18 AM11/23/09
to
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
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
0 new messages