Today I was responding to a question related to Transaction Log backups through SQL Server Maintenance Plans. In order to simulate the same problem, I tried creating a maintenance plan in SQL Server 2005 on my laptop. Surprise! While trying to add a new Backup Task, the following error message was displayed.
It was not clear what would have gone wrong by looking at the error message. Like I did in this post, I started the Process Monitor tool by filtering sqlwb.exe. Here is what I got.
The DdsShapes.dll file existed in the correct location but while loading it there were lot of NAME NOT FOUND errors. What had changed in my laptop recently? I had installed SQL Server 2005 SP4 couple of weeks back. This was the first time I had tried creating a Maintenance Plan after installing SP4. The installation of SP4 was reported to be *successful*.
Since DdsShapes.dll file was reported to be having issues, I navigated to
C:Program FilesMicrosoft SQL Server90ToolsBIN folder to check if the file existed there. It did. Since it is common to see the dll files getting messed up during installation of Service Packs, I tried the easiest approach of registering that dll again.
regsvr32 "C:Program FilesMicrosoft SQL Server90ToolsBINDdsShapes.dll"
Voila! Issue fixed and the Maintenance Plan was created successfully. One more reason why I love all the sysinternals tools.