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)
24,03
bisher 26,99

Sie sparen: 10 %

inkl. gesetzl. MwSt.
Versandfertig in 1 - 2 Wochen
Versandkostenfrei
In den Warenkorb
Filialabholung

Versandkostenfrei

Bezahlung bei Abholung

Andere Kunden interessierten sich auch für

  • 45243079
    Fantastic Beasts and Where to Find Them. The Original Screenplay
    von Joanne K. Rowling
    (8)
    Buch (gebundene Ausgabe)
    16,99 bisher 21,49
  • 44725232
    Harry Potter and the Cursed Child - Parts I & II (Special Rehearsal Edition)
    von John Tiffany
    (55)
    Buch (gebundene Ausgabe)
    19,99
  • 39151356
    Harry Potter: The Complete Collection
    von Joanne K. Rowling
    (6)
    Buch (Taschenbuch)
    48,95 bisher 71,99
  • 43564382
    Milk and Honey
    von Rupi Kaur
    Buch (Taschenbuch)
    12,99
  • 42413879
    All the Light We Cannot See
    von Anthony Doerr
    (2)
    Buch (Taschenbuch)
    7,87 bisher 10,49
  • 45965122
    The Chemist
    von Stephenie Meyer
    Buch (Taschenbuch)
    13,49 bisher 27,99
  • 34910866
    The Life List
    von Lori Nelson Spielman
    (5)
    Buch (Taschenbuch)
    6,99 bisher 9,70
  • 38930428
    We Were Liars
    von E. Lockhart
    (10)
    Buch (Taschenbuch)
    7,99 bisher 10,49
  • 17914934
    One Line a Day
    von Books LLC Staff Chronicle
    (2)
    Buch
    9,99
  • 31405171
    Game of Thrones 5-Copy Boxed Set
    von George R. R. Martin
    (6)
    Buch (Taschenbuch)
    25,90 bisher 37,49
  • 42769827
    The Girl on the Train
    von Paula Hawkins
    (14)
    Buch (Taschenbuch)
    6,99
  • 39151343
    Harry Potter 1 and the Philosopher's Stone
    von Joanne K. Rowling
    (14)
    Buch (Taschenbuch)
    6,99
  • 43809866
    It Ends with Us
    von Colleen Hoover
    (2)
    Buch (Taschenbuch)
    8,99 bisher 11,50
  • 42416940
    George R. R. Martin's a Game of Thrones Leather Cloth Boxed Set (Song of Ice and Fire Series)
    von George R. R. Martin
    Buch (Leder)
    49,50 bisher 70,76
  • 41516671
    Scratch the World
    Buch (Poster)
    22,99
  • 46395110
    Tools of Titans
    von Timothy Ferriss
    Buch (Taschenbuch)
    13,99
  • 39151342
    Harry Potter 2 and the Chamber of Secrets
    von Joanne K. Rowling
    Buch (Taschenbuch)
    6,99
  • 45996981
    The Bikini Body 28-Day Healthy Eating & Lifestyle Guide
    von Kayla Itsines
    Buch (Taschenbuch)
    17,99 bisher 23,49
  • 41812060
    Harry Potter and the Philosopher's Stone. Illustrated Edition
    von Joanne K. Rowling
    Buch (gebundene Ausgabe)
    29,99
  • 40476149
    After You
    von Jojo Moyes
    Buch (Taschenbuch)
    7,99

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)
24,03
bisher 26,99
+
=
Troubleshooting SQL Server - A Guide for the Accidental DBA

Troubleshooting SQL Server - A Guide for the Accidental DBA

von Ted Krueger

Buch (Taschenbuch)
29,99
+
=

für

54,02

inkl. gesetzl. MwSt.

Alle kaufen