SQL Server backup and recovery

MUST READ Restore basics: How to restore using T-SQL commands TIP - SQL Server Enterprise Manager may be a quick and easy way to run backups and restores, but T-SQL commands offer much greater flexibility. Selecting a SQL Server recovery model TIP - SQL Server 2000 offers three recovery models: full recovery, simple recovery and bulk-logged Recovery. Greg Robidoux discusses choosing the best one for your needs. Tips for scheduling and testing SQL Server backups TIP - Learn how to schedule backups in SQL Server and SQL Server Express using SQL Server Agent, BACKUP DATABASE command, maintenance plan and Task Scheduler. Tricking SQL Server into making full database backups TIP - Learn to create full SQL Server backups in a customized log shipped environment by tricking SQL Server into thinking it owns the log shipped database files. Checklist: Maximize SQL Server backup performance TIP - Improve the I/O throughput of SQL Server backups with this checklist by Edgewood Solutions' Greg Robidoux. It includes optimal backup configuration and scheduling options.

EXPERT TECHNICAL ADVICE: 1 - 3 of 118

SQL SERVER BACKUP AND RECOVERY EXPERTS
			Greg Robidoux Founder, Principal Database Engineer ASK A QUESTION

	Tips for scheduling and testing SQL Server backups Submitted By: Denny Cherry | 31 Mar 2008 TIP - Learn how to schedule backups in SQL Server and SQL Server Express using SQL Server Agent, BACKUP DATABASE command, maintenance plan and Task Scheduler.

	Code to restore SQL Server databases in VB.NET 20 Feb 2008 EXPERT ANSWER - Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert.

	Tricking SQL Server into making full database backups Submitted By: Jason A. Gerrish | 05 Feb 2008 TIP - Learn to create full SQL Server backups in a customized log shipped environment by tricking SQL Server into thinking it owns the log shipped database files.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER BACKUP AND RECOVERY

REFERENCE & LEARNING: 1 - 3 of 36

	Top 7 SQL Server backup and restore tips of 2007 SearchSQLServer.com | 02 Jan 2008 THE YEAR IN REVIEW - Optimize SQL Server backup and restore methods natively with these best practices. Check out the top seven most viewed tips of 2007 on the topic of backup and recovery.

	Replication techniques in SQL Server Heidi Sweeney, Associate Editor | 27 Aug 2007 LEARNING CENTER - The following list will educate you on the replication process in SQL Server and also guide you on how to enhance your techniques when replicating your database(s).

	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.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER BACKUP AND RECOVERY

NEWS: 1 - 3 of 9

	Microsoft offers beefed-up backup beta SearchWinIT.com | 27 Sep 2006 ARTICLE - System Center Data Protection Manager 2006 version 2 now covers Exchange 2000 Server, Exchange Server 2003, SQL Server 2000 and SQL Server 2005.

	SQL Server DBMS' growing popularity is no coincidence SearchSQLServer.com | 05.26.2006 OPINION - SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of ...

	Q&A: What's new in SQL Server 2005 SP1 SearchSQLServer.com | 04 May 2006 INTERVIEW - SQL Server 2005 Service Pack 1 provides production-ready Database Mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and more.

	VIEW ALL NEWS ON SQL SERVER BACKUP AND RECOVERY

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 - 2 of 2

	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.

	SQL Server backup and restore school Published by: SearchSQLServer.com | 16 Aug 2007 WEBCAST AND PODCAST SERIES - In this SQL Server backup and recovery school, you'll get best practices, basic restore commands and learn SQL Server 2005 features – all via webcasts and podcasts.

	VIEW ALL DOWNLOADS ON SQL SERVER BACKUP AND RECOVERY

BEST WEB LINKS: 1 - 2 of 2

	SQL Server disaster recovery About.com | 22 Jul 2005 BEST WEB LINK - Database failures and disaster recovery usually isn't thought about it until it is too late. This article outlines steps you should address soon after configuring your SQL Server.

	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.

	VIEW ALL BEST WEB LINKS ON SQL SERVER BACKUP AND RECOVERY

DEFINITIONS: 1 - 1 of 1

	rollback 31 Jul 2003 WORD - A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed. A commit is the final step when it has determined that a transaction has been completed successfully.

	VIEW ALL DEFINITIONS ON SQL SERVER BACKUP AND RECOVERY

	SEE ALSO - Topics Related to SQL Server backup and recovery:  SQL Server Online Transaction Processing (OLTP), SQL Server clustering, SQL Server security, SQL Server availability, 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