Clustering SQL

Are there any major issues in clustering SQL 2000 on a Windows 2003 cluster?
Will with is also be fine for SQL 2005 on a Windows 2003 cluster?
No major issues. But take a read of these articles:
http://support.microsoft.com/kb/888121
http://support.microsoft.com/kb/301520
http://support.microsoft.com/kb/327270
http://support.microsoft.com/kb/815431
http://support.microsoft.com/kb/301600
http://support.microsoft.com/kb/872931
Linchi
"Peter Downes" <pjtdownes@.hotmail.com> wrote in message
news:OQH5msk4EHA.3840@.tk2msftngp13.phx.gbl...
> Are there any major issues in clustering SQL 2000 on a Windows 2003
cluster?
> Will with is also be fine for SQL 2005 on a Windows 2003 cluster?
>
|||Are there huge performance benfits in clustering SQL? Would a second
identical server in a cluster double the performance?
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
> No major issues. But take a read of these articles:
> http://support.microsoft.com/kb/888121
> http://support.microsoft.com/kb/301520
> http://support.microsoft.com/kb/327270
> http://support.microsoft.com/kb/815431
> http://support.microsoft.com/kb/301600
> http://support.microsoft.com/kb/872931
> Linchi
> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
> news:OQH5msk4EHA.3840@.tk2msftngp13.phx.gbl...
> cluster?
>
|||I would add that you need to do 817064 BEFORE 301600
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
> No major issues. But take a read of these articles:
> http://support.microsoft.com/kb/888121
> http://support.microsoft.com/kb/301520
> http://support.microsoft.com/kb/327270
> http://support.microsoft.com/kb/815431
> http://support.microsoft.com/kb/301600
> http://support.microsoft.com/kb/872931
> Linchi
> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
> news:OQH5msk4EHA.3840@.tk2msftngp13.phx.gbl...
> cluster?
>
|||A database; or an instance of SQL for that matter, will only run on one
server at a time - clustered or not. You can not load balance SQL databases
across servers.
The benefit to clustering SQL is High Availability. Oh, and its really cool.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Peter Downes" <pjtdownes@.hotmail.com> wrote in message
news:%237I81Xl4EHA.1120@.TK2MSFTNGP11.phx.gbl...
> Are there huge performance benfits in clustering SQL? Would a second
> identical server in a cluster double the performance?
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
>
|||Thanks for the advice!
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:e1u6mbl4EHA.2624@.TK2MSFTNGP11.phx.gbl...
> I would add that you need to do 817064 BEFORE 301600
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
>