Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jun 14, 2002

SQL Server 2000 Administration in 15 Minutes a Week: Database Backups

By Michael Aubert

Welcome to the seventh article in my series SQL Server Administration in 15 Minutes a Week. Last week we learned what T-SQL is and we also saw how the transaction logs are used to track changes in the database. This week we are going to look at how to backup our databases. The topics for this article include:

-- Why Backups are important
-- Database Backup Types 
-- Database Recovery Models
-- Making a backup

Why Backups are important

One of the most important tasks you will face as a DBA is performing backups. Although backups are certainly not the most interesting part of the job, they are probably the single most important. If something goes wrong it's the DBA's job to get the server back up and running as quickly as possible. Loss of productivity or, even worse, loss of data can be very expensive for a company. Let's look at the most common question I'm asked when talking about backups.  

Why not just use a RAID configuration that has mirroring to provide protection? RAID is certainly the first line of prevention for data loss. Depending on the RAID configuration you use, one or even several hard drives can fail before the data is lost. Additionally, the use of hot swappable and hot standby drives can be used to allow the server to continue without ever having to be taken offline in the event a hard drive fails. The key thing to notice here is that RAID can protect you if a hard drive fails, but what happens if a fire or natural disaster occurs? What do you do if your database files become corrupted due to hardware or software errors? Or what happens if a user deletes data that they later need? A RAID configuration will not help you if any of these events occurs. 

Remember, you can always replace the server, but the data on that server is extremely difficult, if not impossible, to recover.

Page 2: Database Backup Types

 » See All Articles by Columnist Michael Aubert

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM