I have a SQL 08 Standard box that I would like to use a Maintenance Plan to backup a database over a network share? Is this possible as the GUI won't let me do that? It tells me it can't find the path. The SQL service has permissions to write on the share.
This is usually because the SQL server is running under an account that does not have permission to access the network shares.
If your SQL server account is not running under a "real" AD account, this might be the time to set that up. It's simple enough to do:
(May I suggest you test this first before shutting down a live SQL server)
Then you can specify share permissions on the network folder to state that the SQL Server account has full read/write access, but others might only have read access, or perhaps no access at all.
|show 1 more comment|