SQL Server Backup and Recovery

MUST READ How to restore from a transaction log in SQL Server TIP - Edgewood Solutions' Greg Robidoux walks you through the process of backing up and restoring data from transaction logs. 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. 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. 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.

EXPERT TECHNICAL ADVICE: 1 - 3 of 126

	The keys to database backup protection for SQL Server Submitted By: SearchSQLServer.com | 22 Jun 2009 TIP - Learn to test and secure your database backups for SQL Server environments to ensure your backups stay protected and ready to go when you need them.

	Choosing a SQL Server disaster recovery solution Submitted By: SearchSQLServer.com | 18 Mar 2009 TIP - Determining your goals is the first step to selecting a DR technology. Here's how to weigh the pros and cons of the myriad options depending on your business requirements.

	Can I encrypt and restore a database backup in SQL Server 2005? 02 Oct 2008 EXPERT ANSWER - Discover the best solutions for encrypting, decrypting and restoring a database in SQL Server 2005.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER BACKUP AND RECOVERY

REFERENCE & LEARNING: 1 - 3 of 23

	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.

	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 BACKUP AND RECOVERY

WHITE PAPERS

	Databases and ERP Selection: Oracle vs SQL Server Published by: IFS | 19 Jun 2009 WHITE PAPER - How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.

Leveraging Virtualization for Application Assurance Published by: AppAssure Software | 09 Jun 2009 WHITE PAPER - Business continuity. Application assurance. Virtualization. Consider that a mission-critical progression. Virtualization answers the need for business continuity and challenge of application assurance enabling companies to quickly and seamlessly recover from e-mail outages and keep business on track.

Hitchcock Schools Protects SQL Servers and Data with Replay AppImage Published by: AppAssure Software | 09 Jun 2009 CASE STUDY - The IT group at Hitchcock is responsible for all the end-user devices, network equipment, and servers that support students, teachers, administrators, and education programs. Central to their mission is protecting data that resides on SQL servers. That would be a much bigger worry if it weren't for Replay AppImage.

	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

NEWS: 1 - 3 of 7

	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.

	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.

	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.

	VIEW ALL NEWS ON SQL SERVER BACKUP AND RECOVERY

WEBCASTS: 1 - 3 of 4

	Overview of Microsoft Business Intelligence Solution on the HP Windows Integrity Platform - Vendor Webcast VIEW WEBCAST PREMIERED:   08 NOV 2006, 02:00 EST (07:00, GMT) SUMMARY:   View this Webcast to learn how to combine and optimize SQL technology and BI initiatives to meet the needs and increasing complexity of your crucial data.

Recovery Model Options in SQL Server - Expert Podcast DOWNLOAD PODCAST PREMIERED:   25 OCT 2006, 09:00 EDT (13:00, GMT) SUMMARY:   In this podcast, SQL Server backup and recovery expert Greg Robidoux describes each of the three recovery models available for SQL Server including full-recovery, bulk-log recovery and simple recovery. Robidoux will guide you toward making the right recovery model choice for your SQL Server environment.

	Crash Course in SQL Server Capacity Planning - Expert Webcast VIEW WEBCAST PREMIERED:   26 OCT 2006, 09:00 EDT (13:00, GMT) SUMMARY:   Attend this webcast to hear from industry expert Hilary Cotter about the tools required to get up to speed and off the ground with SQL Server capacity planning.

	VIEW ALL WEBCASTS 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:  Microsoft SQL Server Tools and Utilities, Microsoft SQL Server Installation, SQL Server Interoperability, SQL Server Replication, Microsoft SQL Server Performance Monitoring and Tuning, SQL Server Security, SQL Server High Availability, Scalability and Reliability