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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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?
dbruntonQuid, Me Anxius Sum?  Illegitimi non carborundum.Commented:
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)?
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.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

dbruntonQuid, Me Anxius Sum?  Illegitimi non carborundum.Commented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
jsgouldAuthor Commented:
Thanks for the input. I'll go over the options. thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Disaster Recovery

From novice to tech pro — start learning today.