Common mistakes made while building and maintaining database
+ Add Slide
2
No backup

This is the worst mistake that can be made yet it is the most common mistake. Backups are of three types full, differential, and transaction logs. The choice will depend on your customer’s requirement. It is not only important to take backup but plan storage of the backup in altogether different location or safety vaults. This area is mostly covered in the business continuity planning and disaster management practises adopted by many companies. It is also advisable to run the backup at times just to ensure that they will work in the hour of need. However, never commit the mistake of running it on your actual database, instead try in a test box or a testing environment.

Related
© 2012, Gizmowatch. Some rights reserved.