SQL Server Backup
Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
Microsoft SQL Server enables users to back up and restore their databases. The SQL Server backup and restore component provides an important safeguard for protecting critical data stored in SQL Server databases. A well-planned backup and restore strategy helps protect databases against data loss caused by a variety of failures.
A copy of data that can be used to restore and recover the data is called a backup. Backups let users restore data after a failure. Additionally, database backup is useful for routine administrative purposes, such as copying a database from one server to another, setting up database mirroring and archiving.
The scope of a backup of data (a data backup) can be a whole database, a partial database, or a set of files or file groups. For each of these, SQL Server supports full and differential backups. A full backup contains all the data in a specific database or set of file groups or files, and also enough log to allow the recovery of that data. A differential backup is based on the latest full backup of the data. This is known as the base of the differential, or the differential base. Usually, a differential base is used by several successive differential backups. At restore time, the full backup is restored first, followed by the most recent differential backup.
Learn more about SQL server backup software.
REQUEST A QUOTE
can give you a quote
REQUEST A DEMO
live, complimentary webinar
Select Terms
- Application Consolidation
- Application Protection
- Archiving
- Array-based
- Backup and Recovery
- Backup for databases
- Backup software
- Bare-Metal Restore
- Business Continuity
- Capacity planning
- CDP
- Cloud Recovery
- Clustering
- Clustering storage
- Contingency planning
- Continuous Data Protection
- Data deduplication
- Data management
- Data recovery
- Data vaulting
- Deduplication
- Disaster Recovery
- Disk imaging
- eDiscovery
- Electronic data archiving
- Email and file archiving
- Email recovery
- Exchange Backup
- Failover
- High Availability
- ILM
- In-band
- Incremental forever
- Information Lifecycle Management
- Message Level Restore
- Migration strategies
- Mirroring
- Network Backup
- Out-of-Band
- Remote backup
- Replication Software
- SAN / NAS
- Server Backup Software
- Server Disk Imaging
- Server operating system
- SharePoint Backup
- SQL Server Backup
- Tape backup
- Tape Backup Software
- Tape Library
- Tiered storage
- Virtual tape libraries
- Virtualization
- WAN optimization
In This Section
- Free eBook
- Blog
- AppAssureTV
- Backup 2.0 University
- White Papers
- Tech Docs
- Glossary
- Backupipedia
- Newsletters
- Free Tools
Free Software Tools
Latest eBook Chapter
Chapter 12: Tales from the Trenches: My Life with Backup 2.0
In the second chapter of this book, I shared with you some of the horror stories of Backup 1.0. I did so primarily as a way of highlighting how poorly our traditional backup techniques really meet our business needs. In this chapter, I want to do the opposite: share with you some stories of Backup 2.0, both from my own experience and from stories you readers have shared over the year‐long production of this book. Names have been changed to protect the innocent, of course, but I think you’ll find these to be compelling examples of how Backup 2.0 has been applied. Where possible, I’ll share information about the infrastructure that goes with these stories so that you can see some of the creative and innovative ways Backup 2.0 is being used in organizations like your own.
Follow AppAssure
