SQL Server Backup and Restore
| eBook | Free |
| Rating |  |
| Author | Shawn McGehee |
| Publisher | Self-publishing |
| Published | 2012 |
| Pages | 381 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1906434743 |
| ISBN-13 | 9781906434748 |
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
- Shawn McGehee (2 books)
Similar Books
Microsoft SQL Server 2012 with Hadoop 
by Debarchan Sarkar
With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indee...
Price: $23.99 | Publisher: Packt Publishing | Release: 2013
Beginning Backup and Restore for SQL Server
by Bradley Beard
Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as the reliability and manageability of restoring from backups. In today's data-driven world, the most important asset that a company has ...
Price: $26.76 | Publisher: Apress | Release: 2018
Building Custom Tasks for SQL Server Integration Services, 2nd Edition
by Andy Leonard
Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS ...
Price: $34.99 | Publisher: Apress | Release: 2021
A Developer's Guide to Data Modeling for SQL Server
by Eric Johnson, Joshua Jones
Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...
Price: $6.15 | Publisher: Addison-Wesley | Release: 2008
Expert SQL Server Transactions and Locking
by Dmitri Korotkevitch
Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you devel...
Price: $24.23 | Publisher: Apress | Release: 2018
Microsoft SQL Server 2012 Integration Services
by Wee-Hyong Tok, Rakesh Parida, Matt Masson, Xiaoning Ding, Kaarthik Sivashanmugam
Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you'll handle compl...
Price: $8.80 | Publisher: Microsoft Press | Release: 2012
Microsoft SQL Server 2008 Management and Administration
by Ross Mistry, Hilary Cotter
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's f...
Price: $9.87 | Publisher: SAMS Publishing | Release: 2008
SQL Server 2019 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni
Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...
Price: $48.15 | Publisher: Microsoft Press | Release: 2020