Browsing articles tagged with " maintenance plan"
Nov
5
2011

SQL 2005 Maintenance plan multiple errors: System.MissingMethodException: Method not found: ‘Boolean Microsoft.SqlServer.

SQL2005_maint_plan_error_05Nov11.jpg

Today while fixing SQL 2005 SP2 (9.00.3042) maintenance plan issues, came across three errors, first error is due to dts dll not registered properly, whereas second one is occuring when trying to create/edit schedule or creating a maintenance plan thorugh Wizard mode. Read below to understand the issue and how it is fixed. 1. While trying to open maintenance plan, recieved following error, To fix this error, I have used the technique which I have […]

Jul
7
2011

Editing Jobs / Maint plans not possible on SP2 tools if server name > 30 characters in length

SQL2005_maintplan_error_07July11.jpg

Today, while doing some maintenance plan modification encountered a unique issue, recieved following error while modifying/opening any maintenance plan or job, Error Screenshots: Job error: Maintenance Plan error: Later on investigation found that this is a known bug with SQL Server 2005 SP2 that if SQL Server name exceeds 30 chars then this issue will occur, for e.g. if SQL server name is dazsqlmper234_1234\dbajsasalsa_456 Issue: SQL Agent Jobs and Maint plans are not editable when […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 457 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2017
M T W T F S S
« May    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: