SQL Server Backup and Recovery

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Big data a big deal for SQL Server 2012, users say

    SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. 

  • BMC buys into continuous data protection

    IT management firm BMC partnered with disaster recovery startup XOsoft to sell continuous data protection (CDP) technology as part of BMC's backup software. This is the latest in a string of recent partnerships by major systems vendors around CDP, bu... 

  • TimeData

    TimeSpring's TimeData continuous data protection (CDP) software allows SQL Server 2005 Customer Technology Preview (CTP) users to test and migrate real-time production data from SQL Server 2000 without shutting down, slowing down or exporting data. T... 

  • Step-by-Step Guide: How to properly back up a SQL Server

    Edgewood Solutions' Greg Robidoux offers a three-part guide for putting together a SQL Server backup process -- planning, testing and implementation. 

  • Step 5: Use constraints and relationships to keep out bad data

    Learn why you must use SQL Server's CHECK constraints to enforce constraints on inserted data. 

  • Step 1: Back up, optimize and enable safety features

    Step 1 of our data integrity guides explains how to develop your data integrity strategy. 

  • Step 4: Obtain hotfixes and prepare for deployment

    Learn how to obtain the latest hotfixes for your SQL Server products. 

  • Step 2: Obtain service packs and prepare for deployment

    Learn how to obtain service packs and prepare for deployment in this SQL Server patch management guide. 

  • DBAs make plans for unknown disasters

    Some DBAs are finding that they aren't as prepared for a flood, fire or power outage in their data center as they thought they were. Careful contingency planning begins with the entire IT team, according to a DBA expert. 

  • Two new utilities for SQL Server released

    Russian software maker Point International has released a pair of utilities for Microsoft's SQL Server. Attach DB is designed for simple administrator tasks with command line arguments. FindInSQL finds string occurrence in SQL Server objects. Both ut... 

  • AlwaysOn Availability Groups

    AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together. 

  • database replication

    Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued) 

  • rollback

    A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed. 

About 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.