Thalia.de

SQL Server Backup and Restore

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.

… weiterlesen
In den Warenkorb
Filialabholung

Versandkostenfrei

Bezahlung bei Abholung

Beschreibung

Produktdetails


Einband Taschenbuch
Seitenzahl 408
Erscheinungsdatum 01.05.2012
Sprache Englisch
ISBN 978-1-906434-86-1
Verlag Red Gate Books
Maße (L/B/H) 244/191/28 mm
Gewicht 707
Buch (Taschenbuch, Englisch)
26,99
inkl. gesetzl. MwSt.
Versandfertig in 1 - 2 Wochen
Versandkostenfrei
In den Warenkorb
Filialabholung

Versandkostenfrei

Bezahlung bei Abholung

Andere Kunden interessierten sich auch für

  • 47566547
    Good Night Stories for Rebel Girls
    von Francesca Cavallo
    Buch (gebundene Ausgabe)
    19,99
  • 34910866
    The Life List
    von Lori Nelson Spielman
    (5)
    Buch (Taschenbuch)
    6,99 bisher 9,70
  • 38930428
    We Were Liars
    von E. Lockhart
    (11)
    Buch (Taschenbuch)
    7,99 bisher 10,49
  • 46008893
    4 3 2 1 (4321)
    von Paul Auster
    (1)
    Buch (gebundene Ausgabe)
    13,99
  • 41817426
    Everything, Everything
    von Nicola Yoon
    Buch (Taschenbuch)
    7,99
  • 46576306
    The Hate U Give
    von Angie Thomas
    Buch (gebundene Ausgabe)
    9,99 bisher 13,49
  • 31405171
    Game of Thrones 5-Copy Boxed Set
    von George R. R. Martin
    (7)
    Buch (Taschenbuch)
    25,90 bisher 39,99
  • 39151356
    Harry Potter: The Complete Collection
    von Joanne K. Rowling
    (8)
    Buch (Taschenbuch)
    52,95 bisher 77,00
  • 15399647
    Nineteen Eighty-Four (1984)
    von George Orwell
    Buch (Taschenbuch)
    6,99
  • 46448633
    The Legend of Zelda: Art & Artifacts
    von Nintendo
    Buch (gebundene Ausgabe)
    26,99 bisher 40,99
  • 47063173
    The Hanging Tree
    von Ben Aaronovitch
    (1)
    Buch (Taschenbuch)
    6,79 bisher 7,99
  • 46576290
    Unfiltered
    von Lily Collins
    Buch (gebundene Ausgabe)
    11,99
  • 46442116
    A Darker Shade of Magic 03. A Conjuring of Light
    von V. E. Schwab
    (1)
    Buch (Taschenbuch)
    7,99
  • 46023261
    The Noise of Time
    von Julian Barnes
    Buch (Taschenbuch)
    6,99
  • 40337600
    A Darker Shade of Magic 01
    von V. E. Schwab
    (2)
    Buch (Taschenbuch)
    6,99 bisher 7,99
  • 4570744
    The Curious Incident of the Dog in the Night-Time
    von Mark Haddon
    (11)
    Buch (Taschenbuch)
    6,29 bisher 6,99
  • 47704027
    Unfiltered: No Shame, No Regrets, Just Me
    von Lily Collins
    Buch (gebundene Ausgabe)
    15,99
  • 32895326
    The Perks of Being a Wallflower
    von Stephen Chbosky
    (25)
    Buch (Taschenbuch)
    6,99
  • 39151343
    Harry Potter 1 and the Philosopher's Stone
    von Joanne K. Rowling
    (14)
    Buch (Taschenbuch)
    6,99
  • 17914934
    One Line a Day
    von Books LLC Staff Chronicle
    (2)
    Buch
    9,99 bisher 13,49

Kundenbewertungen


Es wurden noch keine Bewertungen geschrieben.

Wird oft zusammen gekauft

SQL Server Backup and Restore

SQL Server Backup and Restore

von Shawn McGehee

Buch (Taschenbuch, Englisch)
26,99
+
=
SQL Server Execution Plans

SQL Server Execution Plans

von Grant Fritchey

Buch (Taschenbuch)
25,99
+
=

für

52,98

inkl. gesetzl. MwSt.

Alle kaufen