Backup database

I'm trying to make a backup via Admin->System->Maintenance but I always get a message :

Cannot open backup device 'D:\MyPath\Presentation\Nop.Web\Administration\db_backups\database_2016-12-08-14-30-32_8621.bak'. Operating system error 3(The system cannot find the path specified.). BACKUP DATABASE is terminating abnormally.

The path exist, but there are no *.bak. Why my website can't make backups?

Hello,

I am having the same problem.

Is your hosting company Arvixe?

Thanks,
Tony

No, I run my website from local server.

I am getting a different error than you are getting.

Typically it is a permission issue to the folder you are backing up to.

I'm sorry I can't offer more than that.

Tony

Anakondra wrote:

Your database have problems.


Carneno wrote:

If you are unable to backup your database, please ask your hosting provider to provide the backup for you. Then, you can download via FTP.

LOVEdotnet wrote:

My hosting company already has a backup function.  I'm not having a problem with that.  I was having a problem with the nopCommerce 3.80 backup and it is finally working now after they fixed some permission issue in their file system.

Thanks,
Tony

@Carneno
Did you get the nopC admin backup to work with SmarterAsp.Net?   It would surprise me a bit, because they typically host their databases on different servers than they host their IIS  (as is recommended by Microsoft), and the file path generated on the web server would not exist on the DB server.

Carneno wrote:

Hi Tony,

ooo.... Great to hear your issue resolved. :)

I KNOW THIS IS LATE BUT IF YOU STILL NEED HELP WITH THIS:


If you are hosting NopCommerce on your own Windows server and it is also the SQL database server:


Go to Administrative Tools > Services and go down to the "SQL Server (MSSQLSERVER)" unless you installed a named instance in which case the name in parentheses will be different but choose that one and go to the Log On tab.

If you installed it with defaults, more than likely the user will be

NT Service\MSSQLSERVER

for whatever user is present here, this is the account you must have permissions for on the db_backup folder. To add this particular user, when you click Add on the Security tab, you must type in EXACTLY

NT Service\MSSQLSERVER in order to find the user on the server. Make sure the user object types are all selected when you enter in the search. Give this user Modify permissions on the db_backups folder.

If your user account is different then add the one listed on the Log On tab of the service.


Once completing this, do an iisreset and then attempt to back up the database again. It should be successful now.

[email protected] wrote:

Thank you