What is the simple recovery model?

April 27th, 2008 by uCertify Leave a reply »

The simple recovery model is the simplest form of recovery model as it requires least administrative efforts. The backup of transaction log is not required in this recovery model. When the simple recovery model is implemented on a database, it automatically truncates the transaction log backup. The database can be recovered only to the point it was last backed up. This model is appropriate for the read-only databases.

  • Share/Bookmark
Advertisement

Leave a Reply

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.