azure sql db backup/restore

Posted: July 15, 2019 at 11:55 AM Quote #242522
Hello - I am trying to back up the SQL database on Azure and restore it to a local SQL server.  The Azure database is a MS SQL server running as a service, therefore the backup is achieved by creating a backpac file.  The Azure backup fails because of an encrypted stored procedure named ProductLoadAllPagedNopAjaxFilters installed with Nop Ajax Filters.

How do I back up my database?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: July 16, 2019 at 12:19 AM Quote #242536
mikehiga wrote:
Hello - I am trying to back up the SQL database on Azure and restore it to a local SQL server.  The Azure database is a MS SQL server running as a service, therefore the backup is achieved by creating a backpac file.  The Azure backup fails because of an encrypted stored procedure named ProductLoadAllPagedNopAjaxFilters installed with Nop Ajax Filters.

How do I back up my database?


You can exclude the said Stored Procedure, it's added by Ajax Filters plugins by nop-templates. The said SP can be added later by running plugin installation again. :)


This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Lam Woon Cherk
https://www.pronopcommerce.com

Looking to double your store's sale? Check out this plugin: http://bit.ly/2YVP8GT
(And no, it's not about putting more marketing money to get more traffics)

Sign up to my mailing list for tons of tips on nopCommerce: http://bit.ly/2fg5fMy
Posted: July 16, 2019 at 9:47 AM Quote #242550
That works for a one-time backup.  Thanks!

How would we handle nightly backups when we go live?  I'm not really sure what benefits this plugin brings to the table, but if it's not really adding value, I'm thinking of removing it permanently.  Any advice on removing this plugin?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: July 17, 2019 at 4:13 AM Quote #242589
You should be able to configure so that this SP is excluded? :)


This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Lam Woon Cherk
https://www.pronopcommerce.com

Looking to double your store's sale? Check out this plugin: http://bit.ly/2YVP8GT
(And no, it's not about putting more marketing money to get more traffics)

Sign up to my mailing list for tons of tips on nopCommerce: http://bit.ly/2fg5fMy
Posted: July 17, 2019 at 10:37 AM Quote #242610
Thank you for the advice.  I don't know if it's possible to exclude objects from a backup job, but I will look into this.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: 2 days ago Quote #244721
Just to close off this topic, I removed Nop Ajax Filters Pro (Nop-Templates.com) from my web site.

Now my backup jobs run successfully.  Bear in mind, this seems to only be a problem when using Azure SQL Database Service as it has a different way of backing up the database than a traditional SQL server database.

I hope I never get in a position where I require Nop Ajax Filters Pro (Nop-Templates.com).
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2019
Learn more