Author Options:

Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system? Answered

We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set this database into Bulk-Logged Recovery Model? We are taking full backups on daily basis. So is there some operations which are not logged in Bulk-Logged Recovery Model compared to Simple Recovery Model?



Try more reliable and advance SQL Database Recovery software. This software easy to recover all SQL data including tables, stored procedure, functions, views, rules, triggers and associated Primary Key, Unique keys, etc. Read more information and free download click here http://utilitysoftwarereview.com/sqldatabaserepair.html

SQL Database Recovery is an apt and powerful solution and uses effective recovery algorithms to provide quick and efficient recovery and flawless results. It repairs views, tables, damaged primary keys, unique keys and foreign keys.Read more :- http://www.undeletepcfiles.com/sql-database-recovery-tool.html

I suggest you to use SQL database recovery software that is specially designed for such purposes. You can try their demo version and they apparently show you the recovered database, and if you do see your deleted tables then you can safely save them too.



In case if your SQL database have been corrupted or you have lost stored SQL objects then you need to use third-party SQL Database Recovery Software. It is effective software developed with latest techniques and strong algorithm with the help of which you can easily repair and restore the corrupt SQL database.

Visit:- http://www.filesrecoverytool.com/sql-database-repair.html

Bulk Logged will not help you in this situation. Your transaction log is growing because you are performing large transactions. In simple mode, the log is truncated after a checkpoint.

Check these site: http://www.sql.recoverytoolbox.com/ & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.

Read more: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/380-is-it-good-idea-to-change-simple-recover-model-into-bulk-logged-on-etl-system