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.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • 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.