SQL Database access for Backup

jsgould
jsgould used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ITSysTechSenior Systems Administrator

Commented:
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)?

Author

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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Quid, 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.
ITSysTechSenior Systems Administrator
Commented:
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?

Author

Commented:
Thanks for the input. I'll go over the options. thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial