Cari Blog Ini

17 Oktober 2012

When To Use of Backup Strategies - Full Backup - Simple Mode

Full Backup - Simple Mode

When you follow this strategy,
the DBA configures the database recovery model to simple,
and performs periodic Full Database backups.

This is the simplest backup strategy, and the simplest to restore.
But it is also the one that takes the longest to back up and is not feasible in most scenarios.

You can use this strategy in the following cases:

* Development Databases:
Databases used in developing or testing environments,
if you can afford to lose daily work,
otherwise consider a Full and Log Backup strategy.

* Stage Databases:
Databases used in Data Warehouse to stored intermediate data extracted from source systems.

* Read Only Databases:
Databases that have only read only information,
for example subscriber databases that store information for reporting purposes.

* System Databases: master, msdb and distribution.
Do not back up tempdb.
And unless you plan to change its contents,
do not back up the model database.
Backing up Master also backs up the ResourceDB.



Because the transaction log is never backed up and it is never truncated;
the recovery mode should be changed to simple mode
to avoid the continuing growth of the database.

Use the Full Backup simple mode strategy only on
development, read only, stage or system databases.
For example,
you can schedule daily backups every night or every weekend of all system databases.



Source:
Ebook: Best Practices For Backup And Restore In SQL Server 2005
By Javier Loria, Courtesy of DELL
Page 5