SQL Server availability

MUST READ Database mirroring setup in SQL Server 2005 TIP - SQL Server 2005 database mirroring allows you to automatically mirror database contents. Learn how it works and how to get it up and running with Management Studio. SQL Server 2005 log shipping setup using the wizard TIP - Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish. Podcast: SQL Server high availability options PODCAST - In this podcast series, you'll get the basics and best practices for each SQL Server high availability option including database mirroring, replication and log shipping. SQL Server clustering best practices TIP - SQL Server clustering provides high availability to clients by sharing server resources over several nodes, but only when all of its dependencies are addressed. SQL Server consolidation pros and cons TIP - You may want to consolidate SQL Servers to reap the reduced licensing, hardware and administrative costs, but there are various "gotchas" to consider before making such a move.

EXPERT TECHNICAL ADVICE: 1 - 3 of 45

	Tips for moving from SQL Server local disk storage to SANs Submitted By: SearchSQLServer.com | 14 May 2008 TIP - Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.

	How to process SQL Server 2005 Analysis Services for data availability Submitted By: SearchSQLServer.com | 01 May 2008 TIP - SQL Server 2005 Analysis Services offers data availability options for processing cube partitions. Learn how to decrease SQL memory, CPU and disk use for availability.

	SQL Server 2005 log shipping setup using the wizard Submitted By: Hilary Cotter | 14 Apr 2008 TIP - Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER AVAILABILITY

REFERENCE & LEARNING: 1 - 3 of 26

	Podcast: Log shipping in SQL Server: Basics to best practices By Eric Johnson | 24 Jul 2007 PODCAST - Learn how to back up a primary SQL Server database and restore it to a secondary server using log shipping. Find best practices on log shipping for high availability.

	SQL Server INSIDER: The ezine with tips for SQL Server pros 22 May 2007 EZINES & EBOOKS - Our easy-to-download online magazine covers Microsoft's flagship database enterprise server, SQL Server and its latest release SQL Server 2005 (Yukon).

	Database mirroring in SQL Server 2005 SearchSQLServer.com | 24 Jun 2007 PODCAST - What is database mirroring in SQL Server and how can it benefit your environment? In this podcast, learn types of mirroring for High Availability and how to configure them.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER AVAILABILITY

NEWS: 1 - 3 of 4

	SQL Server 2005 Database Mirroring primer SearchSQLServer.com | 21 Feb 2006 INTERVIEW - Edgewood Solutions' Greg Robidoux answers some common questions about Database Mirroring in SQL Server 2005.

	Letters to the editor: Educating database end users SearchSQLServer.com | 11 Jan 2006 LETTERS TO THE EDITOR - As a SQL Server DBA or developer, what knowledge would you pass along to end users to help ease your burdens in the new year? Read what your peers have to say.

	Letters to the Editor: Are DBAs needed anymore? SearchOracle.com | 31 May 2005 LETTERS TO THE EDITOR - The increasing automation of the DBMS and the evolving role of the DBA has been a hot topic among you database professionals. Here's a small sample of your feedback to the editor.

	VIEW ALL NEWS ON SQL SERVER AVAILABILITY

WHITE PAPERS

	Microsoft Dynamics™ CRM Integration into the Contact Center Published by: AMC Technology | 09 May 2008 WHITE PAPER - This technical integration brief explains how the Microsoft Dynamics CRM application can be integrated into a contact center, including both general technical details of call center integration, as well as how to use vendor certified software f...

	100+ Year Old Wholesale Grocer Uses CONNX to save Millions on Enterprise Systems Replacement Costs Published by: CONNX Solutions | 08 May 2008 CASE STUDY - Explore how a data access and integration solution saved one of North America's oldest wholesale grocers from replacing its ten year old distribution system and spending up to five million dollars on a brand new enterprise solution.

	Real World SQL Implementations Published by: Hewlett-Packard Company | 10 Apr 2008 WHITE PAPER - Homeplans, part of Move, is a leading provider of pre-drawn home designs. This case study explains how Homeplans used HP PolyServe Software for Microsoft SQL Server to improve availability, decrease risk, and simplify administration.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

DOWNLOADS: 1 - 1 of 1

	Podcast: SQL Server high availability options Published by: SearchSQLServer.com | 27 Aug 2007 PODCAST - In this podcast series, you'll get the basics and best practices for each SQL Server high availability option including database mirroring, replication and log shipping.

	VIEW ALL DOWNLOADS ON SQL SERVER AVAILABILITY

BEST WEB LINKS: 1 - 3 of 4

	SQL Server 2000 Survival Guide http://www.akadia.com/services/sqlsrv_programming.html | 22 Jul 2005 BEST WEB LINK - Here you find step-by-step resources for architecting, administering and managing SQL Server 2000.

	Achieving massive scalability with SQL Server SQL-Server-Performance.com | 07 Mar 2005 BEST WEB LINK - Doug Kerwin explains how to achieve massive scalability with SQL Server using techniques such as clustering, federated database design and continuous replication.

	High availability resources Microsoft | 21 Feb 2005 BEST WEB LINK - These resources from Microsoft TechNet can help you ensure high availability of your SQL Server DBMS.

	VIEW ALL BEST WEB LINKS ON SQL SERVER AVAILABILITY

	SEE ALSO - Topics Related to SQL Server availability:  SQL Server Online Transaction Processing (OLTP), SQL Server backup and recovery, SQL Server clustering, SQL Server security, SQL Server data warehousing/business intelligence, SQL Server installation, SQL Server integration/interoperability, SQL Server replication, SQL Server database design and modeling, SQL Server performance and tuning