SQL Server Backup and Recovery
Home > SQL Server Topics > Microsoft SQL Server Administration > SQL Server Backup and Recovery
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS     RSS FEEDS 

SQL Server Backup and Recovery


Having a reliable and well-tested backup and recovery procedure is essential to protecting your SQL Server data when things go wrong. Get help establishing, maintaining, testing and verifying your backup and restore plan from the SQL Server best practices in this section. Learn about areas such as backup and recovery enhancements in Microsoft SQL Server 2005, how to restore a SQL Server database and how to strategize a disaster recovery plan to retrieve all SQL Server data. You'll also find a checklist on how to maximize SQL Server backup performance, plus tips on how to schedule and test your backups.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (126) , REFERENCE & LEARNING (23) , WHITE PAPERS , DOWNLOADS (2) , NEWS (7) , WEBCASTS (4) , DEFINITIONS (1)

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



SQL Server Backup and Recovery Solutions - SQL Server Topics

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts