My Database backup never ends. I was able to previously backup the database in less then a minute. Now my backup runs forever and never ends.
It has a wait Type of "MSSEARCH"
I stopped the backup.
I then Killed the backup (kill spid).
The Backup still shows in the Activity Monitor. The only way I found to get it stop is to reboot the server. This is currently not an option.
Does anyone have other ideas on how to kill this Backup.
Once it is stopped what can I do to figure out what is wrong with the database and why it will not backup.
It has been many days since I have been able to successfully run a backup on the database.
It has a wait Type of "MSSEARCH"
I stopped the backup.
I then Killed the backup (kill spid).
The Backup still shows in the Activity Monitor. The only way I found to get it stop is to reboot the server. This is currently not an option.
Does anyone have other ideas on how to kill this Backup.
Once it is stopped what can I do to figure out what is wrong with the database and why it will not backup.
It has been many days since I have been able to successfully run a backup on the database.