SQL Server backup and recovery
Home > SQL Server Topics > SQL Server Administration > SQL Server backup and recovery
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS   SQL SERVER INFO CENTERS   RESOURCE CENTERS     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 best practices found here.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (118) , REFERENCE & LEARNING (36) , NEWS (9) , WHITE PAPERS , DOWNLOADS (2) , BEST WEB LINKS (2) , DEFINITIONS (1)

MUST READ
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.
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.

  EXPERT TECHNICAL ADVICE: 1 - 3 of 118
SQL SERVER BACKUP AND RECOVERY EXPERTS
Greg Robidoux
Founder, Principal Database Engineer
ASK A QUESTION
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.
Tricking SQL Server into making full database backups
Submitted By: Jason A. Gerrish | 05 Feb 2008
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.
VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER BACKUP AND RECOVERY

  REFERENCE & LEARNING: 1 - 3 of 36
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
Microsoft Dynamics™ CRM Integration into the Contact Center
Published by: AMC Technology | 09 May 2008
WHITE PAPER - This technical integration brief explains how the Microsoft Dynamics CRM application can be integrated into a contact center, including both general technical details of call center integration, as well as how to use vendor certified software f...
100+ Year Old Wholesale Grocer Uses CONNX to save Millions on Enterprise Systems Replacement Costs
Published by: CONNX Solutions | 08 May 2008
CASE STUDY - Explore how a data access and integration solution saved one of North America's oldest wholesale grocers from replacing its ten year old distribution system and spending up to five million dollars on a brand new enterprise solution.
Real World SQL Implementations
Published by: Hewlett-Packard Company | 10 Apr 2008
WHITE PAPER - Homeplans, part of Move, is a leading provider of pre-drawn home designs. This case study explains how Homeplans used HP PolyServe Software for Microsoft SQL Server to improve availability, decrease risk, and simplify administration.
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

  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


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

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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