Avatar of Ralph Gould
Ralph Gould
Flag for United States of America asked on

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.
DatabasesDisaster RecoverySQL

Avatar of undefined
Last Comment
Ralph Gould

8/22/2022 - Mon
ITSysTech

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?
dbrunton

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)?
Ralph Gould

ASKER
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 help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
dbrunton

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
ITSysTech

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Ralph Gould

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