Re: SQL Server Upgrade

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Phil wrote:
Hi,

Can someone help, I have just been given an old SQL Server which is running SQL Server 2000 with SP1, can I upgrade this straight to SQL Server 2005? What I have read says that it's ok to upgrade from SP3 but nothing from SP1. If needs be I will clear the installation and start from scratch and import all the necessary data just wanted to know if there was an easier way of going about this?

Thanks Phil

Download SP4, apply it and then upgrade to 2005. I just did this on a test server and it went well...

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services
.

Relevant Pages

  • Re: Connecting remotely through VPN
    ... Reason: Your upgrade is blocked. ... Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books ... information about edition upgrades, see the Version and Edition Upgrades ... I think that your SQL Browser Service did not work well. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2005 wont upgrade using R2 discs
    ... But when I try and upgrade the default instance I still get this error: ... Microsoft SQL Server 2005 Tools ... I uninstalled the SQL 2000 version and it let me install ... information about edition upgrades, ...
    (microsoft.public.windows.server.sbs)
  • Re: Creating a new Access database file (.mdb) in .NET/C#
    ... You definitely need to download my Ebook. ... It can be passed around as a file like JET and backed up in a similar fashion. ... Consider that this database is also fully encryptable--a feature not in JET or in SQL Server until 2008. ... Per the MS product pages, I'm eligible for the Upgrade package, and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL 2005 wont upgrade using R2 discs
    ... Microsoft SQL Server 2005 Tools ... I uninstalled the SQL 2000 version and it let me install ... But I assume I need to upgrade the default instance too, ... information about edition upgrades, ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem upgrading named instance in SQL 2000
    ... Reason: Your upgrade is blocked. ... "Hardware and Software Requirements" topics in SQL Server 2005 Setup ... Service pack requirement check: ... Version and Edition Upgrades topic in SQL Server 2005 Setup ...
    (microsoft.public.sqlserver.clients)