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
Verkaufsrang 5.190
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
    (3)
    Buch
    14,95 bisher 16,99
  • 44725232
    Harry Potter and the Cursed Child - Parts I & II (Special Rehearsal Edition)
    von Joanne K. Rowling
    (33)
    Buch
    19,99
  • 39151356
    Harry Potter: The Complete Collection
    von Joanne K. Rowling
    (3)
    Buch
    48,95 bisher 71,99
  • 42769827
    The Girl on the Train
    von Paula Hawkins
    (1)
    Buch
    7,40
  • 30674192
    A Raisin in the Sun
    von Lorraine Hansberry
    (1)
    Buch
    6,80
  • 45571862
    ZAYN
    von Zayn
    (2)
    Buch
    17,95 bisher 23,11
  • 3061941
    A Raisin in the Sun
    von Lorraine Hansberry
    Buch
    6,99
  • 34910866
    The Life List
    von Lori Nelson Spielman
    (5)
    Buch
    6,99 bisher 9,70
  • 43564382
    Milk and Honey
    von Rupi Kaur
    Buch
    12,99 bisher 14,99
  • 6609307
    Fahrenheit 451
    von Ray Bradbury
    (2)
    Schulbuch
    10,25
  • 39151343
    Harry Potter 1 and the Philosopher's Stone
    von Joanne K. Rowling
    (1)
    Buch
    7,90
  • 32901389
    The Hunger Games
    von Suzanne Collins
    (1)
    Schulbuch
    8,99
  • 17345365
    Looking for Alaska
    von John Green
    (2)
    Schulbuch
    10,25
  • 42413879
    All the Light We Cannot See
    von Anthony Doerr
    (2)
    Buch
    7,85 bisher 10,49
  • 38930428
    We Were Liars
    von E. Lockhart
    (6)
    Buch
    7,99 bisher 10,49
  • 44896091
    Born to Run
    von Bruce Springsteen
    Buch
    18,95
  • 4570744
    The Curious Incident of the Dog in the Night-Time
    von Mark Haddon
    (7)
    Buch
    6,99
  • 29974749
    Me Before You
    von Jojo Moyes
    (6)
    Buch
    8,85 bisher 11,80
  • 39100939
    An Introduction to the Study of English and American Literature
    von Vera Nünning
    Buch
    14,99
  • 43809866
    It Ends with Us
    von Colleen Hoover
    (1)
    Buch
    8,99 bisher 11,50

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

Troubleshooting SQL Server - A Guide for the Accidental DBA

von Jonathan Kehayias

Buch
26,85
bisher 29,99
+
=

für

50,88

inkl. gesetzl. MwSt.

Alle kaufen