Guys I am at my wits end with this problem.
We have Arcserve 11.1 and SQL agent latest version installed on a seperate SQL server but try as I might, I cannot get a back up from it. There are two instances of SQL on the server and one backs up perfectly but the other does not. I have tried using windows authentication and sql but to no avail.
I have set backup agent service to run as local sys, loacal admin and domain admin but this did not help. I get different errors every time I try to make changes or use different security settings. Here are some of the logs:--
Job No....................... 2
Job ID....................... 143
Workstation.................. DXXXXMSSQL01
Source....................... dbasql@CASEMAN\ElectronicRegister
Target....................... 11/02/05 11:29 AM, ID B2BE, Sequence #1
Session...................... 6
Start Time................... 11/02/05 11:51 AM
Session Method............... Backup Agent - Database (Full)
E8604
Failed to start backup. (DBNAME=ElectronicRegister, EC=DXXXXMSSQL01:[SQL Server] szSqlState = 37000,fNativeError = 3265, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.)
E8604
Failed to start backup. (DBNAME=ElectronicRegister, EC=DXXXXMSSQL01:Backup Agent Error - (73) "SQL Server error. Please check the log file DBASQL.LOG".)
Total Database(s)............ 1
Total Skip(s)................ 0
Total Size (Disk)............ 1 KB
Total Size (DB).............. 0 KB
Total Size (Media)........... 64 KB
Elapsed Time................. 2s
Average Throughput........... 1.87 MB/min
Total Error(s)/Warning(s).... 12/0
Session Status............... Failed
Job No....................... 2
Job ID....................... 143
Workstation.................. DXXXXMSSQL01
Source....................... dbasql@CASEMAN\DASCaseManLive
Target....................... 11/02/05 11:29 AM, ID B2BE, Sequence #1
Session...................... 7
Start Time................... 11/02/05 11:52 AM
Session Method............... Backup Agent - Database (Full)
E8604
Failed to start backup. (DBNAME=DASCaseManLive, EC=DXXXXMSSQL01:[SQL Server] szSqlState = 37000,fNativeError = 3265, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.)
E8604
Failed to start backup. (DBNAME=DASCaseManLive, EC=DXXXXMSSQL01:Backup Agent Error - (73) "SQL Server error. Please check the log file DBASQL.LOG".)
Total Database(s)............ 1
Total Skip(s)................ 0
Total Size (Disk)............ 1 KB
Total Size (DB).............. 0 KB
Total Size (Media)........... 64 KB
Elapsed Time................. 1s
Average Throughput........... 3.75 MB/min
Total Error(s)/Warning(s).... 14/0
Session Status............... Failed
Job No....................... 2
Job ID....................... 143
Workstation.................. DXXXXMSSQL01
Source....................... dbasql@CASEMAN\DASCaseMan
Target....................... 11/02/05 11:29 AM, ID B2BE, Sequence #1
Session...................... 8
Start Time................... 11/02/05 11:52 AM
Session Method............... Backup Agent - Database (Full)
Also a common error is
unable to open file. File=\\servername\d$\mssql\databasename.mdf, ec=sharing violation w304
suicidal
please help
We have Arcserve 11.1 and SQL agent latest version installed on a seperate SQL server but try as I might, I cannot get a back up from it. There are two instances of SQL on the server and one backs up perfectly but the other does not. I have tried using windows authentication and sql but to no avail.
I have set backup agent service to run as local sys, loacal admin and domain admin but this did not help. I get different errors every time I try to make changes or use different security settings. Here are some of the logs:--
Job No....................... 2
Job ID....................... 143
Workstation.................. DXXXXMSSQL01
Source....................... dbasql@CASEMAN\ElectronicRegister
Target....................... 11/02/05 11:29 AM, ID B2BE, Sequence #1
Session...................... 6
Start Time................... 11/02/05 11:51 AM
Session Method............... Backup Agent - Database (Full)
E8604
Failed to start backup. (DBNAME=ElectronicRegister, EC=DXXXXMSSQL01:[SQL Server] szSqlState = 37000,fNativeError = 3265, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.)
E8604
Failed to start backup. (DBNAME=ElectronicRegister, EC=DXXXXMSSQL01:Backup Agent Error - (73) "SQL Server error. Please check the log file DBASQL.LOG".)
Total Database(s)............ 1
Total Skip(s)................ 0
Total Size (Disk)............ 1 KB
Total Size (DB).............. 0 KB
Total Size (Media)........... 64 KB
Elapsed Time................. 2s
Average Throughput........... 1.87 MB/min
Total Error(s)/Warning(s).... 12/0
Session Status............... Failed
Job No....................... 2
Job ID....................... 143
Workstation.................. DXXXXMSSQL01
Source....................... dbasql@CASEMAN\DASCaseManLive
Target....................... 11/02/05 11:29 AM, ID B2BE, Sequence #1
Session...................... 7
Start Time................... 11/02/05 11:52 AM
Session Method............... Backup Agent - Database (Full)
E8604
Failed to start backup. (DBNAME=DASCaseManLive, EC=DXXXXMSSQL01:[SQL Server] szSqlState = 37000,fNativeError = 3265, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.)
E8604
Failed to start backup. (DBNAME=DASCaseManLive, EC=DXXXXMSSQL01:Backup Agent Error - (73) "SQL Server error. Please check the log file DBASQL.LOG".)
Total Database(s)............ 1
Total Skip(s)................ 0
Total Size (Disk)............ 1 KB
Total Size (DB).............. 0 KB
Total Size (Media)........... 64 KB
Elapsed Time................. 1s
Average Throughput........... 3.75 MB/min
Total Error(s)/Warning(s).... 14/0
Session Status............... Failed
Job No....................... 2
Job ID....................... 143
Workstation.................. DXXXXMSSQL01
Source....................... dbasql@CASEMAN\DASCaseMan
Target....................... 11/02/05 11:29 AM, ID B2BE, Sequence #1
Session...................... 8
Start Time................... 11/02/05 11:52 AM
Session Method............... Backup Agent - Database (Full)
Also a common error is
unable to open file. File=\\servername\d$\mssql\databasename.mdf, ec=sharing violation w304
suicidal
please help