Backing up a database is arguably the most important aspect to database administration. Without backups, you cannot recover in cases of data loss or corruption. You cannot rebuild quickly without the data that you, ultimately, are responsible for. Have you ever met a DBA that is sort of mehhhh about backups? I guarantee you that is because they are either lazy or have never had to recover from a catastrophic failure. The worst part about either of those reasons is that one is by choice and one is by circumstance, but both can be remediated with a little foresight and planning. ...
© Bradley Beard 2016
Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_2
2. Backing Up a Database
Bradley Beard1
(1)Palm Bay, Florida, USA
Get Practical Maintenance Plans in SQL Server: Automation for the DBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
