backing up remote SQL with limited priviledge

[reza_akhlaghy]

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 ?

[Ken_Putnam]

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?

[reza_akhlaghy]

Hi

Since it is trial installation, yes I got everything you mentioned. I need to know minimum priviledge requirement to backup SQL database.

[Mahesh_Roja]

Does the BackupExec service account have SQL Admin rights?

• Ensure that the Windows user account that you use to back up the SQL instances has System Administrator privileges.
• Ensure that Backup Exec has rights to the following registry keys:
  • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server
  • HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQL

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

[RahulG]

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