Admin::Recovery Model

 

•  Different Types of SQL Server Database Recovery Models

  • http://www.sql-server-performance.com/articles/dba/Database_Recovery_Models_in_SQL_Server_p1.aspx

  • simple mode

    • In Simple Recovery Model SQL Server logs minimal amount of information in the transaction log. SQL Server basically truncates the transaction log whenever the transaction log becomes 70 percent full or the active portion of the transaction log exceeds the size that SQL Server could recover in the amount of time which is specified in the Recovery Interval server level configuration

• Switching Database Recovery Models

  • http://www.sql-server-performance.com/articles/dba/Database_Recovery_Models_in_SQL_Server_p2.aspx

• How to Switch Database Recovery Model

  • http://www.sql-server-performance.com/articles/dba/Database_Recovery_Models_in_SQL_Server_p3.aspx

이 글은 스프링노트에서 작성되었습니다.