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.
| Author |
Topic |
|
mccoigk
Starting Member
12 Posts |
 Posted - 2007-04-26 : 10:19:51
|
| Ever since upgrading SQL Server 2005 to SP2 build 3050 all my maintenance plans which begin with a Check Database Integrity Task are failing! If I remove the task from the plan they all execute properly. If I run the T-SQL equivalent manually it executes properly.I upgraded the server to build 3054 and rebooted several times and Im still having no luck. What am I doing wrong?Thanks for your help with this.-Kenny |
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2007-04-26 : 10:21:09
|
| Forgot the error number:0, Alter failed for Server 'MARS'. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 13:19:06
|
| Is MARS a sql instance name? Tried recreate plan after patching? I just can't reproduce it on my servers. |
|
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2007-04-26 : 13:39:16
|
| Yes, Mars is our SQL 2005 installation. Within this instance we have mutiple databases. The error occurs on all maintenance plans regardless of the database its assigned to.Yes, in my frustration I completely deleted all plans and recreated them all. It still doesnt function properly.Interestingly enough we do not have this problem on our other sql installations... |
|
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2007-05-10 : 10:41:19
|
| Figured it out based on another post in the forum:Even though the SQL server was running sp2 (version 9.0.3054) the client that I was accessing the server with through Management Studio on my workstation was running version 9.0.3042. Everytime I would create the maintenance plans from my workstation it would fail. After upgrading my workstation Management Studio (the tools) to 9.0.3054 the problem went away! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-10 : 13:30:07
|
| Thanks for taking the trouble to come back and update us. |
|
|
|
sethsolanki
Starting Member
1 Post |
Posted - 2008-11-26 : 10:29:18
|
| I've been told that the latest version of Studio Management was 3042 and that there is no 3054, I installed the CU Hotfix 10 and selected to updated tools and workstation components but the Management Studio remained at 3042. how did you upgrade it? |
|
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2008-11-26 : 12:17:52
|
| I installed it through Microsoft Update. Once I ran it under the category for SQL Server, there was an optional update to the workstation tools which I downloaded and installed. |
|
|
|
|
|
|
Check DB Integrity Task fails in maintenance plan