Hello Friends,
I have a very strange issue on my backup. One of the SQL policy in my backup environment is running twice. Here I am explaning what exactly it is happening:
Policy Name : SQLDiff_Backup
The Schedule Time: 5:00pm
When it triggers automatically the policy is starting in the name of SQLDiff_Backup at 5:00pm and again it triggers automatically at 5:03pm with the name SQLDIFF_BACKUP ( in CAPITAL). But there is only a single instance running for application backup.
For resolution
1) I have deleted the policy and recreated.
2) Deleted the policy from CLASS file also.
But no help. So everyday in morning I found the backup is in connecting state even if application backup jobs are over. So everyday, I have to delete the backup with name SQLDIFF_BACKUP and then backup completes.
Friends please give me any suggestion why backup is automatically running with policy name in CAPITAL. It is really paining now.
Thanks