We have a SQL Server 2000 SP3 in which i have few databases. I would
like to upgrade this server to SP4. This is easy, but the problem is this
server has just 100MB of C:drive with which we are unable to upgrade to SP4
and i cannot delete any of the data in this Drive…so we planned to move this
sql 2000 directly to 2005. Can any one give me some details regarding this
whether this is possible and if YES what do we need to to do inorder to
achieve this GOAL.

Thanks in Advance
Srikanth

--
Srikanth

Hi
Yes it is.
First, I woould run an Upgrade Advisor that you are able to download from MS
site.
Just after upgrading , run update statistics command on SQL Server 2005'
databases.

I'm not sure do you have a cluster environment?


"Srikanth" <u49327@uwe> wrote

The SQL 2005 upgrade will take a lot more than 100 MB on the system disk.

You need to expand that partition or replace it with a larger disk.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Srikanth" <u49327@uwe> wrote

1st of all thanks for your reply.

Is there any other way of upgrading without adding space to the disk
drive....like can we use any virtual server to do this...
Geoff N. Hiten wrote:
--
Srikanth

Message posted via http://www.sqlmonster.com

Lack of space on the system disk won't go away. You need to move something
off of it or replace it with a larger disk.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Srikanth via SQLMonster.com" <u49327@uwe> wrote

thanks, i will try to do something with this....I have one more question...
this is completely different

we are planning to upgrade the existing 2000 active/passive cluster to to
2005 side by side, does any body have any documents with for this. It would
be really helpful if any one provide any help.

Thanks
Geoff N. Hiten wrote:
--
Srikanth

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...ering/200902/1