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,59
inkl. gesetzl. MwSt.
Versandfertig in 1 - 2 Wochen
Versandkostenfrei
In den Warenkorb
Filialabholung

Versandkostenfrei

Bezahlung bei Abholung

Andere Kunden interessierten sich auch für

  • 15365119
    Thirteen Reasons Why
    von Jay Asher
    (13)
    Buch (Taschenbuch)
    8,29
  • 43564382
    Milk and Honey
    von Rupi Kaur
    (2)
    Buch (Taschenbuch)
    12,99 bisher 14,99
  • 47566547
    Good Night Stories for Rebel Girls
    von Francesca Cavallo
    Buch (gebundene Ausgabe)
    16,99
  • 54619015
    Thirteen Reasons Why. TV Tie-In
    von Jay Asher
    Buch (Taschenbuch)
    7,79 bisher 8,99
  • 17283460
    Thirteen Reasons Why
    von Jay Asher
    (13)
    Buch (Taschenbuch)
    6,59
  • 34910866
    The Life List
    von Lori Nelson Spielman
    (5)
    Buch (Taschenbuch)
    6,99 bisher 9,70
  • 1719784
    The Giver
    von Lois Lowry
    (1)
    Schulbuch (Taschenbuch)
    9,99
  • 54193482
    Thirteen Reasons Why
    von Jay Asher
    Buch (Taschenbuch)
    8,99
  • 38930428
    We Were Liars
    von E. Lockhart
    (11)
    Buch (Taschenbuch)
    7,99 bisher 10,49
  • 46576306
    The Hate U Give
    von Angie Thomas
    (1)
    Buch (gebundene Ausgabe)
    9,99 bisher 13,49
  • 23361882
    Thirteen Reasons Why
    von Jay Asher
    Schulbuch (Taschenbuch)
    9,60
  • 17345365
    Cornelsen Senior English Library - Literatur / Ab 10. Schuljahr - Looking for Alaska
    von John Green
    (22)
    Schulbuch (Taschenbuch)
    10,25
  • 4593954
    Cornelsen Senior English Library - Literatur / Ab 10. Schuljahr - The Perks of Being a Wallflower
    von Stephen Chbosky
    (25)
    Schulbuch (Taschenbuch)
    10,25
  • 45243079
    Fantastic Beasts and Where to Find Them. The Original Screenplay
    von Joanne K. Rowling
    (17)
    Buch (gebundene Ausgabe)
    14,95 bisher 21,99
  • 14751780
    Cornelsen Senior English Library - Literatur / Ab 10. Schuljahr - The Curious Incident of the Dog in the Night-Time
    von Mark Haddon
    (11)
    Schulbuch (Taschenbuch)
    10,25
  • 45795728
    Norse Mythology
    von Neil Gaiman
    Buch (gebundene Ausgabe)
    11,59 bisher 12,89
  • 39151356
    Harry Potter: The Complete Collection
    von Joanne K. Rowling
    (9)
    Buch (Taschenbuch)
    52,95 bisher 77,00
  • 40670892
    Perfect
    von Cecelia Ahern
    Buch (Taschenbuch)
    8,69 bisher 9,99
  • 46297446
    Court of Wings and Ruin
    von Sarah J. Maas
    Buch (gebundene Ausgabe)
    17,99
  • 43831163
    A Court of Thorns and Roses 3
    von Sarah J. Maas
    Buch (Taschenbuch)
    8,09

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,59
+
=
SQL Server Transaction Log Management

SQL Server Transaction Log Management

von Gail Shaw

Buch (Taschenbuch)
22,94
bisher 26,99
+
=

für

49,53

inkl. gesetzl. MwSt.

Alle kaufen