Backup database

3 years ago
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?
3 years ago
Hello,

I am having the same problem.

Is your hosting company Arvixe?

Thanks,
Tony
3 years ago
No, I run my website from local server.
3 years ago
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
3 years ago
Anakondra wrote:
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?


Your database have problems.


Carneno wrote:
Hello,

I am having the same problem.

Is your hosting company Arvixe?

Thanks,
Tony


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.
3 years ago
LOVEdotnet 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.


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
3 years ago
@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.
3 years ago
Carneno 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


Hi Tony,

ooo.... Great to hear your issue resolved. :)
1 year ago
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.
1 year ago
[email protected] wrote:
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.


Thank you