Hi,
As mentioned in a previous post, I am trying to backup to a network drive. When I add the dump device using the unc and try to backup, I get the following error message "cannot open backup device. Device error or device off-line.." So I did research on
this error and found out a MS kb which states that this might be happening if I do not have write access to that drive. Now I do have write access there but I know it has something to do with SQL Server trying to write to that shared drive in disguise of
local account instead of me.. (as account). Now, another article here http://www.winnetmag.com/Article/Art...025/14025.html describes what needs to be done but the problem is that I can do all this at my office. But we are creating shrink wrapped
app using MSDE and we will be providing a simple user interface to the client to do backup/restore. So what should I tell my clients or even best what should I do so that the backups to the network share work seemlessly.
The quest is unsatiable!!
This is really a windows issue, not a SQL Server issue. Every piece of software runs under a user account in
Windows (NT). And every user who accesses a resource (like a share) need permissions to that resource. If the
software (user) - SQL Server in this case - doesn't have access to the share, then Windows will not allow
access. You have to make sure that SQL Server is using an account that has permissions on the share in
question.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"whynot" <anonymous@.discussions.microsoft.com> wrote in message
news:92D21681-63A8-40DD-8C86-583DA99F27FB@.microsoft.com...
> Hi,
> As mentioned in a previous post, I am trying to backup to a network drive. When I add the dump device using
the unc and try to backup, I get the following error message "cannot open backup device. Device error or
device off-line.." So I did research on this error and found out a MS kb which states that this might be
happening if I do not have write access to that drive. Now I do have write access there but I know it has
something to do with SQL Server trying to write to that shared drive in disguise of local account instead of
me.. (as account). Now, another article here http://www.winnetmag.com/Article/Art...025/14025.html
describes what needs to be done but the problem is that I can do all this at my office. But we are creating
shrink wrapped app using MSDE and we will be providing a simple user interface to the client to do
backup/restore. So what should I tell my clients or even best what should I do so that the backups to the
network share work seemlessly.
> The quest is unsatiable!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment