Re: Upgrading SQL

Roger wrote:

My Client is running SBS2K3 Prem

We have not upgraded SQL to 2005

I can’t find any info on SBS2K8 Prem

I found hints of Windows Server 2008 and SQL 2008 being released maybe
second quarter next year but nothing on SBS.

My client wants advice on upgrading SQL.

Should they wait for the release of the next version before upgrading?
Should they just upgrade to SQL 2K5 now then upgrade again later?
Should they wait until the release of SBS2K8 when everything is bundled
together thus saving some money?

The number one question regarding SQL is what do their LOB application vendors (or in-house developers) have to say on the matter regarding compatibility with the various editions of SQL Server?

Fat lot of good upgrading from SQL2000 to SQL2005/2008 on SBS if the LOB vendor says "we only support SQL2000".

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.
.

Relevant Pages

  • Re: High Paging
    ... Windows Server 2003/2000/NT ... > You've done a lot with this system, upgrading the SQL database and the OS ... > Windows Server 2003/2000/NT ...
    (microsoft.public.windows.server.general)
  • Re: Moving SQL Server 7.0 database to SQL Server 2000
    ... your application running on SQL 2000 before you do the upgrade. ... For your replication questions the microsoft.public.sqlserver.replication ... "Replication and Upgrading" ... "Replication Between Different Versions of SQL Server" ...
    (microsoft.public.sqlserver.setup)
  • Re: High Paging
    ... You've done a lot with this system, upgrading the SQL database and the OS ... Windows Server 2003/2000/NT ... > memory free from 3.8GB and when I add all the processes memory usage up I ...
    (microsoft.public.windows.server.general)
  • Re: Access 97 to SQL Conversion
    ... I am upgrading the program as we speak. ... > data type incompatibilities. ... >>queries that are trying to build new records in one of the SQL tables keep ... >>the way I set up Autonumbering in SQL? ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL SERVER AGENT NOT STARTING
    ... I upgraded my Windows server 2000 to Windos server 2003 and i also run SQL ... 2000 on the Windows 2003 plat form, but after upgrading i get this error ...
    (microsoft.public.sqlserver.server)