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 52

	Monitor database mirroring and replication after a SQL Server upgrade Submitted By: SearchSQLServer.com | 05 Aug 2008 TIP - Learn how to monitor your database mirroring and replication setup after upgrading an Active/Active cluster to SQL Server 2005.

	Upgrade live applications to SQL Server 2005 for high availability Submitted By: SearchSQLServer.com | 09 Jul 2008 TIP - Part 4 in this series on upgrading an Active/Active cluster to SQL Server 2005 details how to push live data from one cluster to another using a conversion DB and replication.

	SQL Server high availability when upgrading to SQL Server 2005 Submitted By: SearchSQLServer.com | 01 Jul 2008 TIP - Make your goal to support SQL Server high availability when upgrading to SQL Server 2005 using a secondary server. Move to a transition server and then rebuild your source system.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER AVAILABILITY

REFERENCE & LEARNING: 1 - 3 of 28

	Tutorial: Migrating to SANs from local SQL Server disk storage SearchSQLServer.com | 23 Jun 2008 SPOTLIGHT - Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.

	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).

	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

	Best Practices for BlackBerry Administrators Published by: BlackBerry | 18 Aug 2008 WHITE PAPER - This paper "Best Practices for Blackberry Administrators" provides various functions that help administrators to solve various IT issues and maintain their security policy.

	Innovative Business Continuity Solutions with Syncsort BEX Advanced Recovery. Published by: Syncsort | 13 Aug 2008 WHITE PAPER - This paper describes a brief history of data protection solutions, and concludes with a description of an authentic, easily deployable product.

	Backup Express and NetApp: A Better Backup and Recovery Solution Published by: Syncsort | 13 Aug 2008 WHITE PAPER - The new technology which fulfills the ambitious goal combines the benefits of disk-based backup, continuous blocklevel incremental backup, synthesized virtual base and file-level restore.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

WEBCASTS: 1 - 2 of 2

Consolidating SQL Servers on 64-bit for reliability and scalability - Expert Webcast VIEW WEBCAST PREMIERED:   30 NOV 2005, 09:00 EST (14:00, GMT) SUMMARY:   This webcast explains how to consolidate SQL Servers under a single 64-bit platform. It will focus on server consolidation methodologies, capacity planning and implementation, as well as ways to achieve greater SQL Server reliability, scalability and ROI without compromising performance.

	Building a SQL Server Utility for Superior Consolidation and Simplified Management - Vendor Webcast VIEW WEBCAST PREMIERED:   03 NOV 2005, 14:00 EST (19:00, GMT) SUMMARY:   Attend this webcast and find out how you can overcome data management challenges such as low-server utilization rates, sub-optimal availability and unnecessary management hassles with an SQL Server Utility.

	VIEW ALL WEBCASTS ON SQL SERVER AVAILABILITY

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