|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
Hi. I'm getting this error when trying to backup a database: ERROR: Backup of <DB> failed: Cannot open backup device '<Path>'. Operating system error 5(error not found). BACKUP DATABASE is terminating abnormally.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 180
|
Please check permissions, make sure that the account of MS SQL instance has full access to the path.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
Hello
I have the similar problem.
Can you explain what user should have permissions on the folder?
I tried to add all possible SQL registered users and give it Full Access to the folder
BTW, when I try to backup DB on remote server should I specify Temporary Folder on remote server?
Does your software support backup from remote SQL server?
Thank you
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 180
|
Open Computer Management window and select Services node on the left tree. Then you should find the service of your MSSQL instance. Double click on the service and select Log On tab on the Properties window. So, you can see the user account of the instance.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 180
|
Currently the application can backup into .bak files only from a local MSSQL instance. BTW we are going to implemented the possibility to backup into .bak files from remote instances in the near release.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
After some research it looks like SQL Server account what I use doesn't have permissions to create backups.
Thank you for your answer.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
>>> Currently the application can backup into .bak files only from a local MSSQL instance. BTW we are going to implemented the possibility to backup into .bak files from remote instances in the near release.
Thank you. It explained issues in my case.
|
|
|
|
|
