SQL Server backup and recovery

MUST READ SQL Server backup and restore commands to limit downtime TIP - SQL Server backup and restore commands must be achieved in acceptable amounts of time. Learn best practices for using backup and restore commands. 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.

EXPERT TECHNICAL ADVICE: 1 - 3 of 121

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

	SQL Server backups using SAN database snapshots Submitted By: SearchSQLServer.com | 21 May 2008 TIP - This overview on SAN snapshots for the DBA's tool belt reviews performance impact, filegroup and file layout, replication, transaction logs and snapshots for data warehouses.

	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.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER BACKUP AND RECOVERY

REFERENCE & LEARNING: 1 - 3 of 37

	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

	Best Practices for BlackBerry Administrators Published by: BlackBerry | 18 Aug 2008 WHITE PAPER - This paper "Best Practices for Blackberry Administrators" provides various functions that help administrators to solve various IT issues and maintain their security policy.

	Innovative Business Continuity Solutions with Syncsort BEX Advanced Recovery. Published by: Syncsort | 13 Aug 2008 WHITE PAPER - This paper describes a brief history of data protection solutions, and concludes with a description of an authentic, easily deployable product.

	Backup Express and NetApp: A Better Backup and Recovery Solution Published by: Syncsort | 13 Aug 2008 WHITE PAPER - The new technology which fulfills the ambitious goal combines the benefits of disk-based backup, continuous blocklevel incremental backup, synthesized virtual base and file-level restore.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

WEBCASTS: 1 - 3 of 5

	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

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