SQL 2000 x86 on Win2003 x64?

Has anyone tried running SQL2k x86 on a Win 2003 x64 platform?  Any issues?
Also, is there any benefit of running SQL in a x64 environment even though
it's only 32-bit?

LC

Yes.  I run exactly such a system.  Make sure and apply SP4 immediately
after installing.  Also apply hotfix 2040 if you are using AWE memory.

I built it this way because it lets me buy better hardware with a longer
life cycle.  I intend to recycle this server to run native 64-bit SQL 2005
after I have converted our application to that platform.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"LC" <LC@discussions.microsoft.com> wrote in message
news:02BC0547-6D28-4369-9FBE- 9F430E885681@microso
ft.com...
> Has anyone tried running SQL2k x86 on a Win 2003 x64 platform?  Any
> issues?
> Also, is there any benefit of running SQL in a x64 environment even though
> it's only 32-bit?
>
> LC

We have done it recently on one server our database loading applications see
m
to run slowly we are trobleshooting the issue
On the second we just started we can update you later.


Kiran


"Geoff N. Hiten" wrote:

> Yes.  I run exactly such a system.  Make sure and apply SP4 immediately
> after installing.  Also apply hotfix 2040 if you are using AWE memory.
>
> I built it this way because it lets me buy better hardware with a longer
> life cycle.  I intend to recycle this server to run native 64-bit SQL 2005
> after I have converted our application to that platform.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "LC" <LC@discussions.microsoft.com> wrote in message
> news:02BC0547-6D28-4369-9FBE- 9F430E885681@microso
ft.com... 
>
>
>