SQL Server Performance

Changing database recovery models: FULL to BULK-LOGGED and vice-versa

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 14, 2007.

  1. Anonymous New Member

    Since SQL Server version 2000 better enhancement of three types of recovery models: simple, full and bulk-logged are fetching long-run support for all kinds of database activies. As you know such recovery models offer varying levels of recovery for restoring your databases from your backups, overall if there is a bulk data update then "Bulk-logged" recovery advantages include minimal space requirements for transaction logs and the best performance for bulk operations. RECOVERY models affect the way...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/14/changing-database-recovery-models-full-to-bulk-logged-and-vice-versa.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1405" width="1" height="1">

Share This Page