Database backup and recovery systems has always played a crucial role in backingup 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 steps 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 softwares 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.