SQL Server 7 on Windows 2000 Server

[tkl]

We have a copy of SQL Server purchased a few years ago
and it has never been unpacked. We want to use it now
with a few concerns. I appreciate if you could help to
answer the following questions : -

1.) Does SQL Server 7 run on Windows 2000 server?
2.) If I install a new copy of SQL Server 7 into
compresed drive, would it cause any problem?
4.) Can I install SQL Server 7 on other drives (such D
drive) instead of C drive in terms of stability?
5.) Are there many patches need to be appplied?


Many thanks for all your help!

[Cowboy \(Gregory A. Beamer\)]

"tkl" <tkllee@hotmail.com> wrote in message
news:088101c3994c$9b480b20$a501280a@phx.gbl...

> We have a copy of SQL Server purchased a few years ago
> and it has never been unpacked. We want to use it now
> with a few concerns. I appreciate if you could help to
> answer the following questions : -
>
> 1.) Does SQL Server 7 run on Windows 2000 server?

Yes.

> 2.) If I install a new copy of SQL Server 7 into
> compresed drive, would it cause any problem?

I would not do it as it adds unnecessary overhead. It should still run, but
performance would suffer.

> 4.) Can I install SQL Server 7 on other drives (such D
> drive) instead of C drive in terms of stability?

You have complete (well, nearly complete) control over where you install. I
have installed SQL Server to a variety of drives (my home machine has SQL
Server on D:\ with the databases on a separate hard drive).

> 5.) Are there many patches need to be appplied?

I believe the patches are retroactive (as far as SPs). SQL Server 7 is up to
SP5, if I remember correctly. You can check the [url]www.microsoft.com/security[/url]
site and do a search for additional patches after the last SP.

> Many thanks for all your help!

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************