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

Effects of Solid State on Microsoft SQL Server 2008 Published by: Kingston Technology Company, Inc. | 08 Jul 2009 WHITE PAPER - This whitepaper contains the results of testing conducted to better understand how Kingston solid-state disk positively affects the scalability of Microsoft® SQL Server® 2008 databases. The findings shown here are from the end user's perspective, using TPC-C-like benchmarking of a large OLTP database.

Real Time Data Integration: Using Change Data Capture Technology with Microsoft SSIS Published by: Attunity Ltd. | 08 Jul 2009 WHITE PAPER - Change data capture (CDC) technology has become a strategic component of many data warehouse and business intelligence (BI) architectures. Read this paper and learn how to use change date capture technology with Microsoft SQL server intergration services in real time.

	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.

	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