backing up remote SQL with limited priviledge
Created: 27 Sep 2010 | 4 comments
Hi
I was trying to install a trial version for a customer whose DBA does not provide SA of sql to us for backup. Instead, he created a user and grant it db_reader and db_backupoperator to database we want to backup.
Unfortunately it wont work and job will fail with this error:
V-79-65323-3265 An error occured on a query to database MainHT80.
The item MainHT\mainht\mainht80 in use - skipped
Since the error does not show a clue of where to look, please shed some light into it.
Is there anyway to backup a database without sysadmin priviledge on SQL ?
Discussion Filed Under:
Comments
The item
The item MainHT\mainht\mainht80 in use - skipped
Would indicate to me that you were trying to backup the database files as flat-files
Do you have the SQL Agent serial installed in the media server?
Do you have the Remote Agent installed on the SQL server?
Did you get the SQL Agent data?
If this response answers your concern, please mark it as a "solution"
It is trial
Hi
Since it is trial installation, yes I got everything you mentioned. I need to know minimum priviledge requirement to backup SQL database.
Ensure that
Does the BackupExec service account have SQL Admin rights?
For more details refer
Best practices for Backup Exec 2010 Agent for Microsoft SQL Server
http://www.symantec.com/business/support/index?page=content&id=HOWTO21793
If this Info helps to resolve the issue please Mark as Solution
Thanks
refe rthe following document
refe rthe following document to check if the backup exec system account have proper rights on the Sql server
http://www.symantec.com/business/support/index?page=content&id=TECH9922
alos make sure when you run the backup the AOFO option is not selected
try creating a new job and see if that helps
If this response answers your concern, please mark it as a "solution"
Would you like to reply?
Login or Register to post your comment.