SQL Database access for Backup

This is a bit more of what is reasonable and what is allowed. I have a client that pays about 75K per year to a solution provider of a database application that houses medical data. The client wants to add the SQL instance into their disaster recovery plan which requires a username and password to be entered into Acronis so it can properly backup the SQL. The solution provider claims that they can not give us the credentials necessary to do this. There claims as to why all seem to be based on more that they are afraid someone is going to steal their code and not the data. The solution provider statements says they backup the database which it appears by that they create a backup but that is to the same drive as where the SQL resides. Any thoughts or comments on this is greatly appreciated. Something I've never run into before ever.
jsgouldAsked:
Who is Participating?
 
dbruntonCommented:
I suspect it is to cover themselves.

If I'm reading your description properly you want access to their hardware so you can back up the SQL instance.  That's like giving you some of the keys to their kingdom.  I'd be screaming too.  You may only have read/copy access to that folder but It's a big foot in the doorway.  

And if something goes wrong in that folder who is going to get the blame?  Them or you?  Lots of possible finger pointing there.

What you could ask is what their disaster recovery plan is in case that machine goes down.  They may very well have a better solution prepared than what you are proposing.
0
 
ITSysTechSenior Systems AdministratorCommented:
If I understand your situation correctly,  your trying to find if the solution provider is properly backing up your clients SQL instance? Is this correct?
0
 
dbruntonCommented:
If it is backed up to the same drive why can't the backup be copied elsewhere (definitely not on the same drive and definitely not in the same location)?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
jsgouldAuthor Commented:
Sorry I explained that poorly. They definitely only run backups to a directory on the same drive as the SQL Instance that is running. We backup, off site, the directories that contain the backup files. I'm trying to help create an easier solution for disaster recovery other than reinstalling everything from scratch utilizing Acronis Backup and Recovery.  As a Solution Provider,  Is that a normal practice to not provide those credentials? Does some how the solution provider maintain rights over that type of access? Again it seems strange to me that the client can't have access to create images for disaster recovery purposes.
0
 
ITSysTechSenior Systems AdministratorCommented:
dbrunton makes a good point that if they do give you full access and something goes wrong they could easily say that it was your fault that they could not recover your client's data (I would suspect they also do this to keep your client paying for the backup service with them so that your client can't switch to another provider). When you mentioned "They definitely only run backups to a directory on the same drive as the SQL Instance that is running." I'm sure they are using a raid array and the risk of total drive failure is very low.

As for having the recovery data that includes SQL and the backup files in the same recovery image I can see your concern that it will be difficult for you to access this data in a disaster. You are correct that it is easier to recovery only the things that need to be recovered and not everything at once. However, in some recovery scenarios you have to recovery everything at once like synced servers that require them to always be synced.  Instead of using the providers backup can you just create a SQL backup of your own to your location?
0
 
jsgouldAuthor Commented:
Thanks for the input. I'll go over the options. thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.