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


  1. bugarl
    Posts : 1
    Windows 7 Ultimate x64
       New #1

    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 Computer
    Quote Quote

  3. Alejandro85
    Posts : 2,468
    Windows 7 Ultimate x64
       New #2

    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 Computer
    Quote Quote

 

  Related Discussions
What a good idea
in System Security

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
Bulk File Name Change
in General Discussion

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.) :)
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...
good idea
in Chillout Room

Someone came up with a bright idea. http://thereifixedit.files.wordpress.com/2010/02/129093936485899931.jpg
Our Sites
Site Links
About 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 21:34.
Find Us