Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Maintenance Plan Problem

Author  Topic 

nasu
Yak Posting Veteran

50 Posts

Posted - 2009-02-05 : 10:22:54
All of a sudden my backups (kept for 3 days according to my maintenance plan) were gone.

When I try to expand the "Maintenace Plans" folder in Management Studio to check I get the following message:

"Invalid column name 'from_msx'
"Invalid column name 'has_targets' (Microsoft SQL Server, Error: 207)

Any ideas what happened?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-05 : 10:27:24
Upgrade your SQL Server with recent SP3 and recent patch(CU1).There was issue with maintenance plan .
Go to Top of Page
   

- Advertisement -