Directory Image
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with our Privacy Policy.

Database Backup systems

Author: Steve Mosby
by Steve Mosby
Posted: Oct 27, 2017

Database backup and recovery systems have always played a crucial role in backing up systems. It is one of the most important practices in the field of data protection. It provides businesses with confidence that in case of data loss, recovery time will be reduced to the minimum. Database backup is one of the most complicated areas of backup because data used in Data Base Management Systems (DBMS) is constantly modified by many concurrent users and can’t be copied without stopping the service.

Basically, a concept reveals the fact of how the data is been restored, the procedure involves although many a step which is being implemented for the betterment of the data security data backup services. The backing up and restoring databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if the media failure occurs or if the database is somehow damaged (for example, from the user errors).

There are different software which implies different types of procedure and different concept to get the desired results. We will have a peak on the SQL server 2000 to have a detailed perspective. Here are some of the following attributes:

SQL Server 2000 supports the following kinds of backup:

Full database backup (it is a full copy of the database).

Transaction log backup (it contains the copy of the transaction log only).

Differential backup (it contains the copy of only the database pages modified after the last full database backup).

SQL Server 2000 supports three recovery models which determine how your data is backed up and what your exposure to data loss is. There are:

Simple recovery model

Full recovery model

Bulk-Logged recovery model

There can be many of the possibilities of data loss at any time of period in the execution or in the running time. Data loss may include: data or database elements could be accidentally deleted; data could become corrupted by the addition of bad data; hardware, such as a disk or server, could fail; or disasters, such as flooding, could destroy your server and storage media.

About the Author

For more Information visit us at : Web Hosting

Rate this Article
Leave a Comment
Author Thumbnail
I Agree:
Comment 
Pictures
Author: Steve Mosby

Steve Mosby

Member since: Sep 13, 2017
Published articles: 9

Related Articles