SQL Backup causing applications to fail?
pkristolaitis
Posts: 12
Hello everyone;
We've been running SQL Backup in production for a few weeks now and we love it! However, we've run across some quirky behavior with one of our applications.
Specifically, the software is BMC Service Desk Express (a helpdesk ticketing system). Every night that we've run a Red Gate SQL Backup job on that database, the application's services crash, causing additional work for the Service Desk staff. However, we have other software that has similar DB access patterns (e.g. network monitoring tools, nightly batch jobs, etc) that are absolutely fine.
Strangely, this problem does NOT occur when using SQL Server native backups.
We're still trying to figure out exactly what's going on (digging through application logs, etc), but we're wondering if anyone has ever seen anything similar?
I'm more than willing to accept that the BMC software was poorly coded, but it's strange that SQL native backups are fine.
Any insight would be much appreciated.
We've been running SQL Backup in production for a few weeks now and we love it! However, we've run across some quirky behavior with one of our applications.
Specifically, the software is BMC Service Desk Express (a helpdesk ticketing system). Every night that we've run a Red Gate SQL Backup job on that database, the application's services crash, causing additional work for the Service Desk staff. However, we have other software that has similar DB access patterns (e.g. network monitoring tools, nightly batch jobs, etc) that are absolutely fine.
Strangely, this problem does NOT occur when using SQL Server native backups.
We're still trying to figure out exactly what's going on (digging through application logs, etc), but we're wondering if anyone has ever seen anything similar?
I'm more than willing to accept that the BMC software was poorly coded, but it's strange that SQL native backups are fine.
Any insight would be much appreciated.
Peter Kristolaitis
Database Administrator
VON Canada
Database Administrator
VON Canada
Comments
I'm more than willing to accept that the BMC software was poorly coded
Just to close this issue, it looks like it was a problem with the software. The timing was simply coincidental that the problems started popping up the same weekend we installed SQL Backup.
Database Administrator
VON Canada