Delete a maintenance plan after changing SQL Server 2008 name
I've seen a few posts on how to delete an older maintenance plan after you've changed the computer name for a default installation of SQL Server 2008, but none of the posts fully solved the problem. Below is what I had to do--with the caveat that you have to find your own id's:
USE msdb DELETE FROM dbo.sysmaintplan_log WHERE subplan_id = '36F8247F-6A1E-427A-AB7D-2F6D972E32C1' DELETE FROM dbo.sysmaintplan_subplans WHERE subplan_id = '36F8247F-6A1E-427A-AB7D-2F6D972E32C1' DELETE FROM dbo.sysjobs WHERE job_id = '3757937A-02DB-47A6-90DA-A64AE84D6E98' DELETE FROM dbo.sysmaintplan_plans WHERE id = 'C7C6EFAA-DA4D-4097-9F9F-FC3A7C0AF2DB'
Labels: SQL Server, System administration
1 Comments:
thanks, worked for me
By Anonymous, at 1:34 AM
Post a Comment
<< Home