Should i upgrade MS SQL version 8 to the latest SQL

benefits: more functionality
potential problems: not enough resources on that server

what server resources do you have?

Well the main job of the sql server is for our ms sharepoint and ms class server

Is one existing problem with the opt and integrity plans on some of the databases failing i know id have to sort this out before an upgrade but i kinda hoping a newer version will just be a lot better

Then again im thinking a little it if aint broke dont fix it?

the server is a hp proliant G3  2 gig ram dual intel xeon 3.06ghz pro

>Is one existing problem with the opt and integrity plans on some of the databases failing
that usually happens when the databases selected are no longer existing, or transaction log space is short etc.
you should check the sql agent job that is generated by the maintenance plan, take the job step, and run it explicitely in query analyser. that will give you more concrete error messages.

SQL Server 2000's support ends in April 2008.
I would seriously consider upgrading.
Now, whether to upgrade to 2005 or to the upcoming 2008 version is a question...

Well i think an upgrade is going to happen but first i think the maintenance plan needs to be fixed

Angelll can you guide me through the query analyser process, not a big user of SQL

Thanks

I am not sure what part of the instruction is unclear:
* you should check the sql agent job that is generated by the maintenance plan
* take the job step' sql
*and run it explicitely in query analyser.
I assume somewhat that you know how to connect to the server using query analyser, and to run some queries?

Ok think ive worked out the maintenance plans, ive just run the MS program which tests how easy the upgrade would be to 2005 and well lets just say it hasnt got any ticks, what would you suggest hold off the upgrade?

>what would you suggest hold off the upgrade?
yes, until you could fully test an upgrade.

So how would someone like yourself test an upgrade, ? Create a virtual sqlserver running 2000 and then upgrade to ver 2005? If that is the case how would i be sure if the database works with the applications that use the current sql database?

Thats what i thought but with applications such as sharpoint, do you have any suggestions on how without having to create a whole bunch of test servers?