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.
Nop Commerce 2.3 Backup option
- 240
- 2267
- 22/10/2011
- Turkey
Jozsef wrote:
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?
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?
- 240
- 2267
- 22/10/2011
- Turkey
pictoric wrote:
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?
This is a nifty little tool for making sql server backups.
http://sqlbackupandftp.com/
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?
- 18
- 1356
- 08/02/2011
- Romania
calacula wrote:
Thank you,it`s OK!
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?
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!
MVP
Développeur certifié
- 1168
- 12695
- 15/11/2011
- United States
AndyMcKenna wrote:
An update on this: This program will also backup your site directory and auto-FTP it to your server. Can't recommend it enough.
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.