ÃÂ We recently did a windows update on our 2003 server. After the restart, one of our database backup jobs keep hanging. After a little troubleshooting i found that the job gets stuck on distribution database. i am able to backup all the user/system databases, but every time i try to backup distribution database, it just creates a 2kb file and keeps running. I have to manually kill the process. While the backup runs, there is no blocking as well.
The distribution databse isÃÂ 300 MB and the backups worked fine before the restart.
I have peer to peer replicationÃÂ setup on the machine.
Any clues why i can't backup the database?
Any help would be appreciated.
View Complete Post