Data

I am in the planning process of upgrading the hardware on
our cluster. I need info/advice/suggestions on how to go
about this.
I am running an active/active cluster on 2 ML370 servers.
They are running Windows 2000 Advanced Server/SP2, MSSQL
2000 Enterprise/SP2.
I want to know if all I have to do is Failover all
resources from Server2 to Server1, then evict Server2?
Then do all I have to do is run the cluster install? I am
not sure what needs to be done with the SQL instance from
Server2? Do I uninstall it or what? I hope this is clear
enough. Any ideas please let me know.See if this helps -
http://support.microsoft.com/defaul...kb;en-us;243218
Ray Higdon MCSE, MCDBA, CCNA
--
"Viraj" <shethvir@.msu.edu> wrote in message
news:7cf701c3e92f$67e03ef0$a301280a@.phx.gbl...

quote:

---

> I am in the planning process of upgrading the hardware on
> our cluster. I need info/advice/suggestions on how to go
> about this.
> I am running an active/active cluster on 2 ML370 servers.
> They are running Windows 2000 Advanced Server/SP2, MSSQL
> 2000 Enterprise/SP2.
> I want to know if all I have to do is Failover all
> resources from Server2 to Server1, then evict Server2?
> Then do all I have to do is run the cluster install? I am
> not sure what needs to be done with the SQL instance from
> Server2? Do I uninstall it or what? I hope this is clear
> enough. Any ideas please let me know.

---

DAO to ADO conversion

Hi Techies,

We had a database MS-Access with DAO statements and we are upgrading our Database to MS-SqlServer which in need to convert the DAO statements to ADO statements.
What i want to know is there any free tool which converts automatically to convert DAO statements to ADO statements. If so what is it?

If not what is the easiest procedure to convert or otherwise should I have to do it manually convert all those DAO statements(so many). If I have to do it manually can u explain where i need to take care mainly while converting the statements.

Thank UThe Access Upsizing Wizard (http://support.microsoft.com/default.aspx?scid=kb;en-us;325017) is probably what you want.

-PatP