PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

Close Notification

Your cart does not contain any items

SQL Server Backup and Restore by Shawn McGehee at Abbey's Bookshop,
SQL Server Backup and Restore
— —
Shawn McGehee

SQL Server Backup and Restore

Shawn McGehee

$64.95   $58.69

Paperback

Not in-store but you can order this
How long will it take?
English
Simple Talk Publishing
14 May 2012
SQL Server & MS SQL
The duties and responsibilitie:s of a Database Administrator (DBA) make for long and dynamically changing list, ranging from offering query tuning advice, to cutting stored procedures, all the way through to system process design and implementation for high availability. A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. This means that if a database, for whatever reason, gets corrupted, dropped, or otherwise becomes unusable, then it is the DBA's responsibility to restore that database to the state it was in before the problem occurred, or as close as is possible. Of course, this doesn't mean that a DBA is required to restore a database each and every day, just that if disaster does strike the DBA must be prepared to deal with it, regardless of when or why it occurs. If a DBA isn't prepared, and significant data is lost, or databases become unavailable to end users for long periods of time, then that DBA probably won't be in their job for too long. This is why a good, and tested, SQL Server backup and restore plan must be on the top of every administrative DBA's list of tasks. 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 Red Gate'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 Red Gate SQL Backup. 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.
By:  
Imprint:   Simple Talk Publishing
Country of Publication:   United Kingdom
Dimensions:   Height: 235mm,  Width: 191mm,  Spine: 21mm
Weight:   699g
ISBN:   9781906434861
ISBN 10:   1906434867
Pages:   408
Publication Date:  
Audience:   General/trade ,  ELT Advanced
Format:   Paperback
Publisher's Status:   Active

See Also

SQL Server Backup and Restore

Pro SQL Server 2008 Reporting Services...

Rodney Landrum

Paperback

$99.95  $85.37

Not in-store but you can order this

ADD +
SQL Server Backup and Restore

Hands-On Microsoft SQL Server 2008...

Ashwani Nanda

Paperback

$143.95  $129.20

Not in-store but you can order this

ADD +
SQL Server Backup and Restore

Practical Graph Structures in SQL...

Enabling Deeper Insights Using Highly...

Louis Davidson

Paperback

$140.95  $127.20

Not in-store but you can order this

ADD +
SQL Server Backup and Restore

Practical MDX Queries

For Microsoft SQL Server Analysis...

Art Tennick

Paperback

$143.95  $129.20

Not in-store but you can order this

ADD +
SQL Server Backup and Restore

Time and Relational Theory

Temporal Databases in the Relational...

C.J. Date (Independent author, lecturer,...

Paperback

$76.95 

Not in-store but you can order this

ADD +
SQL Server Backup and Restore

Beginning SQL Server 2005 for Developers...

From Novice to Professional

Robin Dewson

Paperback

$107.95  $86.54

Not in-store but you can order this

ADD +