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
>>