Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Is it good idea to change Simple Recover Model into Bulk-Logged on ETL

06 Nov 2014   #1
bugarl

Windows 7 Ultimate x64
 
 
Is it good idea to change Simple Recover Model into Bulk-Logged on ETL

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?


My System SpecsSystem Spec
.
06 Nov 2014   #2
Alejandro85

Windows 7 Ultimate x64
 
 

Judging by the terms used, my best guess it that you're asking something about SQL Server, right?
If so, please specify it, so we can come to an adequate answer.
My System SpecsSystem Spec
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
What a good idea
I found this while ploughing through the mail and thought I might just make a couple of them up, in case. How to Use An Antivirus Boot Disc or USB Drive to Ensure Your Computer is Clean
System Security
Bulk File Name Change
I have 860 .pdf files. The file names are "Map1234", "Map1235", etc. There are gaps in the number sequence that might complicate things. I need to remove the word "Map" from each file name. Can it be done? (Of course, I can do it one by one, but I probably won't live that long.) :)
General Discussion
Reconfigure my Rig? Is it a good idea?
I recently installed a new SSD. Iíve been reading a lot about how having many programs installed on the SSD will decrease its life time. So Iím thinking about reconfiguring the set up. Iím not sure if I should change to mounting the drive to a HD or creating junctions is better? I presently...
Installation & Setup
good idea
Someone came up with a bright idea. http://thereifixedit.files.wordpress.com/2010/02/129093936485899931.jpg
Chillout Room


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 09:07.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App