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

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">