Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 823
  • Last Modified:

Should i upgrade MS SQL version 8 to the latest SQL

Simple question i hope anyway
Is it worth upgrading to the latest version of sql, we are on version 8 at the moment, or will it cause loads of problems?

Are there many benefits?
0
David
Asked:
David
  • 5
  • 5
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
benefits: more functionality
potential problems: not enough resources on that server

what server resources do you have?
0
 
DavidAuthor Commented:
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
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
bamboo7431Commented:
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...
0
 
DavidAuthor Commented:
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
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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?
0
 
DavidAuthor Commented:
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?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>what would you suggest hold off the upgrade?
yes, until you could fully test an upgrade.
0
 
DavidAuthor Commented:
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?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>If that is the case how would i be sure if the database works with the applications that use the current sql database?

you have not only to test the sql upgrade part, but also the applications on that upgraded version.
0
 
DavidAuthor Commented:
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?
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now