Hi,

Can someone , 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

Hello Phil,


Yes, you need to install at least SP3 to upgrade to SQL Server 2005.

You can find more detailed info from the following link:
http://technet.microsoft.com/en-us/l.../ms143393.aspx


--
Ekrem Önsoy



"Phil" <Phil@discussions.microsoft.com> wrote in message
news:51A308C4-3879-4077-9D64-5602E0A8C8CF@microsoft.com...
> Hi,
>
> Can someone , 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

Hi Ekrem,

Thought that might have been the case, in your opinion would I be better of
just starting with a fresh installation of 2005, if I export all the
necessary databases will I be able to re set up the number of jobs that I
need to get working?

Thanks Phil

"Ekrem Önsoy" wrote:

> Hello Phil,
>
>
> Yes, you need to install at least SP3 to upgrade to SQL Server 2005.
>
> You can find more detailed info from the following link:
> http://technet.microsoft.com/en-us/l.../ms143393.aspx
>
>
> --
> Ekrem Önsoy
>
>
>
> "Phil" <Phil@discussions.microsoft.com> wrote in message
> news:51A308C4-3879-4077-9D64-5602E0A8C8CF@microsoft.com...
> > Hi,
> >
> > Can someone , 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
>

Yep, you could do.

Backing up your databases on SQL Server 2000 and restoring them on SQL
Server 2005 would work. However, you better do this backup operation after
installing SP3 or SP4 (this would be better) on your SQL Server 2000. I'm
not sure but there could be some compatibility problems if you don't do this
besides you wouldn't be able to upgrade...

However, just backing up your databases does not mean you backup everything.
For example your Linked Servers, Logins, Jobs etc. would not be restored on
your new SQL Server 2005 box.

--
Ekrem Önsoy




"Phil" <Phil@discussions.microsoft.com> wrote in message
news:2B15D809-2C8B-4C08-A413-35C16BD99553@microsoft.com...
> Hi Ekrem,
>
> Thought that might have been the case, in your opinion would I be better
> of
> just starting with a fresh installation of 2005, if I export all the
> necessary databases will I be able to re set up the number of jobs that I
> need to get working?
>
> Thanks Phil
>
> "Ekrem Önsoy" wrote:
>
>> Hello Phil,
>>
>>
>> Yes, you need to install at least SP3 to upgrade to SQL Server 2005.
>>
>> You can find more detailed info from the following link:
>> http://technet.microsoft.com/en-us/l.../ms143393.aspx
>>
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Phil" <Phil@discussions.microsoft.com> wrote in message
>> news:51A308C4-3879-4077-9D64-5602E0A8C8CF@microsoft.com...
>> > Hi,
>> >
>> > Can someone , 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
>>

Phil wrote:
> Hi,
>
> Can someone , 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