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 128

	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 22

	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.

	Database mirroring in SQL Server 2005 SearchSQLServer.com | 24 Jun 2007 PODCAST - What is database mirroring in SQL Server and how can it benefit your environment? In this podcast, learn types of mirroring for High Availability and how to configure them.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER BACKUP AND RECOVERY

WHITE PAPERS

Reduce CPU Usage with 'SMART' SQL Published by: BMC Software, Inc | 30 Nov 2009 WHITE PAPER - This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.

Presentation Transcript: Data Warehousing Basics for SQL Server Analysis Services Published by: Flowerfire, Inc. | 25 Nov 2009 PRESENTATION TRANSCRIPT - In this transcript of the "Data Warehousing Basics for SQL Server Analysis Services" webcast, learn how to build your data warehouse for your SQL Server environment. Discover the necessary steps involved and learn about major concepts, including relational data warehousing and supported SQL Server Analysis Services (SSAS) storage formats.

	Techfocus SQL Server 2008 Migration: Evaluate the Value of a SQL Server Upgrade Published by: SHI | 24 Nov 2009 EBOOK - SQL Server 2008 has many compelling features, but not all of them are necessary. See what's a good fit for your enterprise and what can wait.

	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