Other Free Encyclopedias » Online Encyclopedia » Encyclopedia - Featured Articles » Featured Articles: Lake Havasu Homes For Sale - Searching for Lake Havasu Homes for Sale - Homes for Less than $100,000 to Cell Phone Compare - The Great Smart Cell Phone Compare - Droid

Sql Server 2000 Backup - SQL Server 2000 Backup Strategies

database backups differential time

Even though it has been over ten years since their introduction, SQL Server 2000 systems remain highly popular for many businesses. While the newer versions support multiple software plug-ins to take care of backup management, SQL Server 2000 backup strategies require manual implementation.

SQL Server 2000 backup strategies are dependent upon a business’ organizational procedures and a skilled IT department to ensure safety against emergency events that can cause a loss of data. Many a business has been caught with their pants down regarding backup protocol, and they subsequently paid such a severe price that it took them years to recover.

Developing Microsoft SQL Server 2000 backup strategies depends directly upon the frequency and length of time that your database can be offline. Once this is determined, a solid procedure can be implemented using either Enterprise Manager or Transact SQL, both basic components of SQL Server 2000.

SQL Server 2000 Full Backups
The full backup is the simplest and most thorough type of backup to perform. Your entire database will be copied onto your choice of backup media, including all users and user permissions. Full backups are often used because they can be done while transactions are being processed in the database. After all of the free database folders are backed up, those that were in use at the time of the initial backup are then appended to the end of the backup.

A full backup SQL Server backup strategy can be accomplished quickly through Enterprise Manager. After expanding the server to display all of the databases, simply right-click on the database you wish to backup. Select All Tasks, and then select Backup Database. A window will display for the database backup options.

Under the General tab, choose the option for Database – complete. You will then need to select an option for tape or disk media. If you have not already done so, you must Add… a backup device, which is the location you will be storing the backup data. After selecting Add…, select either the file name or backup device to proceed. Once the path is defined, it will be available for selection in the list.

Before you can begin the backup, you must choose to either append the last backup or overwrite it. You also have the option of scheduling the backup. There are four scheduling options available:

• Start the backup when the SQL Server Agent starts
• Start the backup whenever the CPU becomes idle
• Schedule a one-time backup by specifying a specific date and time
• Schedule a recurring backup by specifying the date, time, and frequency

Several full backup options are also available. These include verifying the backup, ejecting the tape after the backup, and initializing/labeling the media.

SQL Server 2000 Differential Backups
Differential backups are accomplished in the same manner as full backups in Enterprise Manager except that instead of selecting Database – complete, select Database – differential. This option will allow you to backup only the information that has changed since the last backup.

Differential backups are much faster than full backups and are generally performed more frequently. One of the more popular SQL Server 2000 backup strategies is to use a differential backup on a daily basis and a full backup on either a weekly or monthly basis.

For most businesses, these two simple recovery model backup options are the best of the SQL Server 200 backup strategies, and using them ensures data is always protected against loss.

Ssh Client Windows - The Usefulness of SSH [next] [back] Spyware Software Free - How to Get Spyware Software For Free

User Comments

Your email address will be altered so spam harvesting bots can't read it easily.
Hide my email completely instead?

Cancel or