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 129

	SQL Server Mailbag: Data restoration and DB property management Submitted By: SearchSQLServer.com | 23 Sep 2009 SQL SERVER MAILBAG - In this edition of the SQL Server Mailbag, expert Denny Cherry tackles reader questions on recovering data after a disc crash, restoring databases with limited space and more.

	Achieving high availability and disaster recovery with SharePoint databases Submitted By: SearchSQLServer.com | 28 Aug 2009 TIP - Failover clustering and database mirroring are two useful SQL Server technologies that offer automatic failover within MOSS-related databases.

	How SQL Server recovery models impact your SharePoint databases Submitted By: SearchWinIT.com | 03 Aug 2009 TIP - SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model. But which model is right for your enterprise?

	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

Protecting and Enhancing SQL Server With Double-Take Availability Published by: Double-Take Software | 16 Nov 2009 WHITE PAPER - Double-Take Software provides organizations with a solution that offers distinct recovery and protection advantages over manual Microsoft SQL built-in replication capabilities: Double-Take Availability saves more data real-time and restores that data in a much faster manner.

	The IT Manager’s Guide to SQL Server 2008 Migration Published by: SHI | 03 Nov 2009 EGUIDE - While SQL Server 2008 is now considered stable and beneficial, many businesses are still hesitant to migrate. In this expert E-Guide, brought to you by SearchSQLServer.com and SHI, you will discover the unique advantages offered by a SQL Server 2008 migration.

Dell and Microsoft solutions help ServiceU deliver reliable system performance and create a virtualized environment that reduces power consumption by 50 percent Published by: Dell and Microsoft | 28 Oct 2009 CASE STUDY - ServiceU Corporation was challenged to deploy reliable hardware to support its Microsoft® SQL Server® 2008 environment and virtualize other applications to enhance business flexibility. Read this case study to learn about the benefits that ServiceU achieved through by implementing Dell hardware and Microsoft Hyper-V technology.

	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 SearchSQLServer.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 Stored Procedures, SQL/Transact SQL (T-SQL), SQL Server Security, SQL Server High Availability, Scalability and Reliability