FREE DOWNLOAD OPEN BOOKS

SQL Server Backup and Restore

SQL Server Backup and Restore

by Shawn McGehee


DOWNLOAD EBOOK READ ONLINE SHARE BOOK QR CODE

Book Description

In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool. Capturing backups using SSMS or simple scripts is perfectly fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated and you'll also want to build in some checks that, for example, alert the responsible DBA immediately if a problem arises. The tool of choice in this book for backup automation is Redgate's SQL Backup Pro. Building your own automated solution will take a lot of work, but we do offer some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs

This open book is licensed under a Creative Commons License (CC BY). You can download SQL Server Backup and Restore ebook for free in PDF format (24.4 MB).

Report an issue

Table of Contents

Chapter 1
Basics of Backup and Restore
Chapter 2
Planning, Storage and Documentation
Chapter 3
Full Database Backups
Chapter 4
Restoring from Full Backups
Chapter 5
Log backups
Chapter 6
Log Restores
Chapter 7
Differential Backup and Restore
Chapter 8
Backup and Restore with SQL Backup
Chapter 9
File Backup and Restore
Chapter 10
Partial Backup and Restore

Book Details

Subject
Computer Science
Publisher
Red Gate
Published
2012
Pages
381
Edition
1
Language
English
ISBN13
9781906434748
ISBN10
1906434743
ISBN13 Digital
9781906434854
ISBN10 Digital
1906434859
PDF Size
24.4 MB
License
CC BY

Book Hashtags

Related Books

SQL Server Internals: In-Memory OLTP
SQL Server Internals: In-Memory OLTP

by Kalen Delaney

The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server h...

SQL Server Hardware
SQL Server Hardware

by Glen Berry

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. Relational databases place heavy demands on their underlying hardware and many of these databases are mission-...

Microsoft SQL Server Notes for Professionals
Microsoft SQL Server Notes for Professionals

by GoalKicker

The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....

Migrating SQL Server Databases to Azure
Migrating SQL Server Databases to Azure

by Carl Rabeler

SQL Server is Microsoft's relational database management system (RDBMS). SQL Server can now be hosted entirely in Microsoft Azure, either in a hosted virtual machine (VM) or as a hosted service. Hosting a virtual machine in Azure is known as infrastructure as a service (IaaS), and hosting a service in Azure is known as platform as a service (PaaS)....

Defensive Database Programming with SQL Server
Defensive Database Programming with SQL Server

by Alex Kuznetsov

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. Too often as deve...

Data Science with Microsoft SQL Server 2016
Data Science with Microsoft SQL Server 2016

by Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok

R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Much more than a database server, it's a rich ecostructure with advanced analytic capab...