ARCserve R12 SQL Agent Backup

[davidminter]

Hi,

I have recently upgraded to R12 from 11.5 for both my backup server and the agent on my SQL Server.

Now, when attempting a backup of the SQL Databases using the r12 SQL Agent the software / agent attempts to back up the database to local disk first, then attempt to restore this database before copying this to tape. The DB never actually made it to tape, as it's a live production server and this processed crashed the whole thing !!

This NEVER happened under r11.5, so I can only assume it's a r12 issue. I have logged a call with CA, but at the present time they aren't being all that helpful.

I have checked the r12 software as well as the SQL software (2005) and can find no options which would cause this.

Does anyone have any ideas ?

Thanks

 

[davidmichel]

Sorry no idea but if not already done install cumulative update 2 for 12.0.

 

[sandyboy]

Hi

Can you check if you have selected
" SQL Server Disaster Recovery Elements for the CA ARCserve Backup Database" in the operation TAB ,if yes can u unselect this and see how it goes ...I think the its for t is only for SQLDR session and not other sessions are not restored ...

cheers

Sandy

 

[davidminter]

Thanks for the info Sandy, from the test backups I have run this seems to have sorted it

 

[sandyboy]

Thats Great

- Hope that Entry resolved that case .....cheers Sandy

 

[sandyboy]

Hi ,

Also just wanted to know , when this crashed happen before you selected that option , do you get any error messages in the Event logs with event 17052 , or in the sqlserver logs with messages like LOCK resource ...

cheers , Sandy