SQL Server Performance

Developing a SQL Server Database Backup Plan

Discussion in 'SQL Server News' started by dineshasanka, Feb 26, 2009.

  1. dineshasanka Moderator

    One of the most important parts of the DBAs job is to ensure that proper backups are being taken at the required interval. The last thing that anyone wants to have happen is to be the next JournalSpace.com and having the company have to close because there wasn’t a usable backup of the database.
    The reason for backups is hopefully obvious to all. They are used to recover the database to a usable point in time in the event of a total hardware failure or a user mistake that deletes some or all of the data from the database. Without the ability to restore the database if one of these events were to happen the database would be lost without any ability to get the information back.
    There are three basic kinds of backups that you have to select from within SQL Server. These are the Full Backup, Differential Backup, and the Transaction Log backup. Each of these backups has its own purpose. The types of backups that you take and how often will be dictated by the business units that you support as well as the type of database that you are backing up.
    More http://www.enterpriseitplanet.com/networking/features/article.php/3807376

Share This Page