Solution Guide Bibliography

Updated : November 13, 2002

On This Page

Chapter 1 - Implementing Failover Clustering
Chapter 2 - Implementing Log Shipping
Chapter 3 - Implementing Transactional Replication
Chapter 4 - Implementing Network Load Balancing
Chapter 5 - Implementing Remote Mirroring and Stretch Clustering

Chapter 1 - Implementing Failover Clustering

• "Hardware Compatibility List" on the Microsoft Web site at https://www.microsoft.com/whdc/hcl/default.mspx

• "SQL Server 2000 Failover Clustering" on the Microsoft Web site at https://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

• Article 268363, "Intel Physical Addressing Extensions (PAE) in Windows 2000," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;268363&sd=tech

• Article 274750, "Configure Memory for More Than 2 GB in SQL Server," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech

• Article 254321, "Clustered SQL Server Do's, Don'ts, and Basic Warnings," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;254321&sd=tech

• Article 259267, "Microsoft Cluster Service Installation Resources," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;259267&sd=tech

• Article 239885, "How to Change Service Accounts on a SQL Virtual Server," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;239885&sd=tech

• Article 273673, "SQL Virtual Server Client Connections Must Be Controlled by Clients," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;273673&sd=tech

• "Windows Server System Reference Architecture" on the Microsoft TechNet Web site at https://www.microsoft.com/technet/solutionaccelerators/wssra/raguide/default.mspx

Chapter 2 - Implementing Log Shipping

• "Hardware Compatibility List" on the Microsoft Web site at https://www.microsoft.com/whdc/hcl/default.mspx

• "How to Set Up Log Shipping" on the Microsoft Support Services Web site at https://support.microsoft.com/default.aspx?scid=https://support.microsoft.com/support/sql/content/2000papers/LogShippingFinal.asp

• "Publishing Data Over the Internet Using VPN in SQL Server Books Online"

• Virtual private network (VPN) connections overview on the MSDN Web site at https://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/conn_vpn.mspx

• "All Changes May Not be Rolled Back when Log Shipping Maintenance Wizard Fails," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;298743&sd=tech

• Article 310882, "BUG: sp_resolve_logins Stored Procedure Fails If Executed During Log Shipping Role Change" in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;310882&sd=tech

Chapter 3 - Implementing Transactional Replication

• "Hardware Compatibility List" on the Microsoft Web site at https://www.microsoft.com/whdc/hcl/default.mspx

• "Planning for Transactional Replication" on the MSDN Web site at https://msdn2.microsoft.com/library/bb545450.aspx

• "Transactional Replication Performance Tuning and Optimization" on the MSDN Web site at https://msdn2.microsoft.com/library/aa902656.aspx

• "Transactional Replication and Log Shipping" on the MSDN Web site athttps://msdn2.microsoft.com/library/

• "Publishing Data Over the Internet Using VPN"

• Virtual private network (VPN) connections overview on the MSDN Web site at https://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/conn_vpn.mspx

• Article 310882, "BUG: sp_resolve_logins Stored Procedure Fails If Executed During Log Shipping Role Change " in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;310882&sd=tech

Chapter 4 - Implementing Network Load Balancing

• "Hardware Compatibility List" on the Microsoft Web site at https://www.microsoft.com/whdc/hcl/default.mspx

• "Microsoft Clustering Solutions" on the Microsoft TechNet Web site at https://www.microsoft.com/technet/archive/community/columns/tips/w2kclust.mspx

• "Network Load Balancing Technical Overview" on the Microsoft TechNet Web site at https://www.microsoft.com/technet/prodtechnol/windows2000serv/deploy/confeat/nlbovw.mspx

Chapter 5 - Implementing Remote Mirroring and Stretch Clustering

• "Hardware Compatibility List" on the Microsoft Web site at https://www.microsoft.com/whdc/hcl/default.mspx

• "SQL Server 2000 Failover Clustering" on the Microsoft Web site at https://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

• Article 268363, "Intel Physical Addressing Extensions (PAE) in Windows 2000," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;268363&sd=tech

• Article 274750, "HOW TO: Configure Memory for More Than 2 GB in SQL Server," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech

• Article 254321, "INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;254321&sd=tech

• Article 259267, "Microsoft Cluster Service Installation Resources," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;259267&sd=tech

• Article 239885, "INF: How to Change Service Accounts on a SQL Virtual Server," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;239885&sd=tech

• Article 273673, "INF: SQL Virtual Server Client Connections Must Be Controlled by Clients," in the Microsoft Knowledge Base at https://support.microsoft.com/default.aspx?scid=kb;en-us;273673&sd=tech

• "Windows Server System Reference Architecture" on the Microsoft TechNet Web site at https://www.microsoft.com/technet/solutionaccelerators/wssra/raguide/default.mspx

• SANCastle Fibre Channel Gateway at https://sancastle.com/products/