-
- Novice
- Posts: 5
- Liked: never
- Joined: Mar 17, 2023 1:31 pm
- Full Name: Julie Boisjoli
- Contact:
Backup a SQL DB with an encrypted stored proc?
I have encrypted stored procedures in some of my databases. I get an error when trying to backup DBs with encrypted procs. Is it possible to backup SQL Server DBs (on Azure) with encrypted stored procedures?
-
- Veeam Software
- Posts: 3812
- Liked: 643 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: Backup a SQL DB with an encrypted stored proc?
Hi Julie,
May I ask you to share how do you back up the database using our solution (f.g. is it a regular backup job?), the error you are getting and a support case ID?
Thanks!
May I ask you to share how do you back up the database using our solution (f.g. is it a regular backup job?), the error you are getting and a support case ID?
Thanks!
-
- Novice
- Posts: 5
- Liked: never
- Joined: Mar 17, 2023 1:31 pm
- Full Name: Julie Boisjoli
- Contact:
Re: Backup a SQL DB with an encrypted stored proc?
I am at the investigation stage, deciding if Veeam is the right product to use to backup SQL Server (our SysOps dept uses veeam for servers). So I do not have a regular backup job, I have just been doing tests (backup/restore to different Managed Instance) and noticed that I get an error if I try to backup a DB with an encrypted stored proc. I'm wondering if this is a showstopper (I need to look for a different product - Veeam can't do the job) or if there is a workaround for this.
-
- Veeam Software
- Posts: 3812
- Liked: 643 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: Backup a SQL DB with an encrypted stored proc?
I'd be glad to help you make this decision despite my opinion could be a little bit prejudiced...
May I ask you to review the questions from my previous post and did you try our plug-in for Microsoft SQL Server?
Thanks!

Thanks!
-
- Novice
- Posts: 5
- Liked: never
- Joined: Mar 17, 2023 1:31 pm
- Full Name: Julie Boisjoli
- Contact:
Re: Backup a SQL DB with an encrypted stored proc?
Our Infrastructure team says these are the products we are using to run the backups:
"The products we are using are Veeam Backup and Replication and Veeam Backup for Azure (VBA). VBA version 5 would be the actual product doing the backups and restores"
"The products we are using are Veeam Backup and Replication and Veeam Backup for Azure (VBA). VBA version 5 would be the actual product doing the backups and restores"
-
- Veeam Software
- Posts: 3812
- Liked: 643 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: Backup a SQL DB with an encrypted stored proc?
Hi Julie,
Where do you run SQL databases, on virtual machines in Azure or this is Azure SQL Database (database as a service)? You may have a look at Azure SQL Database backup available in Veeam Backup for Microsoft Azure but please use this forum for all VBA-related questions.
Thanks!
Where do you run SQL databases, on virtual machines in Azure or this is Azure SQL Database (database as a service)? You may have a look at Azure SQL Database backup available in Veeam Backup for Microsoft Azure but please use this forum for all VBA-related questions.
Thanks!
Who is online
Users browsing this forum: Google [Bot], Janne.Haatainen and 139 guests