Nop Commerce 2.3 Backup option

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 anni tempo fa
Hello,

Is there any option to backup my database through admin panel of nopcommerce 2.3 or any other way to do this?

Thanks in advance.
0
12 anni tempo fa
Dimitra wrote:
Hello,

Is there any option to backup my database through admin panel of nopcommerce 2.3 or any other way to do this?

Thanks in advance.


No you have to do it manually by logging onto your database.
2
12 anni tempo fa
How can i do this? please tell me step by step,thank you
0
12 anni tempo fa
Jozsef wrote:
How can i do this? please tell me step by step,thank you


1 Connect your database with "Microsoft SQL Server Manager Studio" or third pary SQL Manager tools.
2 Right clik your database and then follow "\Tasks\Genrate Scripts..." menus
3 On the "Script Wizard" window select necessary options... Attention "Script Logins" and etc. options.
4 Select "Script to file" or "Script to New Query Window" option.
5 After this steps you have your Database objects scripts with Data scripts.
6 When need this backup only copy paste this script Query window and !Execute.

This is my way. Are there other better way?
Please VOTE if this has been of some help.

Kind Regards

https://www.nopSmart.com/
https://www.nopTurk.com/
1
12 anni tempo fa
This is a nifty little tool for making sql server backups.

http://sqlbackupandftp.com/
1
12 anni tempo fa
I'm using that, too.  You might also want to write/find a script to make a copy of the entire website directory on a regular basis, especially if you store your product images on the filesystem instead of in the DB.
StackOverflow - http://stackoverflow.com/users/113988/andymckenna
https://github.com/AndyMcKenna
0
12 anni tempo fa
pictoric wrote:
This is a nifty little tool for making sql server backups.

http://sqlbackupandftp.com/


I just tryed this app. My backup file too small than manual way script. Manual method script file size 64.454 Kb, this app script file size 2.917 Kb at the same database.
Are there any restriction?
Please VOTE if this has been of some help.

Kind Regards

https://www.nopSmart.com/
https://www.nopTurk.com/
0
12 anni tempo fa
I have used that utility for years though I paid for a non free version.  This page outlines the restrictions.  If you have any other questions about it I suggest you ask in their forums.

http://sqlbackupandftp.com/features/
0
11 anni tempo fa
calacula wrote:
How can i do this? please tell me step by step,thank you

1 Connect your database with "Microsoft SQL Server Manager Studio" or third pary SQL Manager tools.
2 Right clik your database and then follow "\Tasks\Genrate Scripts..." menus
3 On the "Script Wizard" window select necessary options... Attention "Script Logins" and etc. options.
4 Select "Script to file" or "Script to New Query Window" option.
5 After this steps you have your Database objects scripts with Data scripts.
6 When need this backup only copy paste this script Query window and !Execute.

This is my way. Are there other better way?



Thank you,it`s OK!
0
11 anni tempo fa
AndyMcKenna wrote:
I'm using that, too.  You might also want to write/find a script to make a copy of the entire website directory on a regular basis, especially if you store your product images on the filesystem instead of in the DB.


An update on this:  This program will also backup your site directory and auto-FTP it to your server.  Can't recommend it enough.
StackOverflow - http://stackoverflow.com/users/113988/andymckenna
https://github.com/AndyMcKenna
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.