Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

'Select Into' logs Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 7:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 9:05 AM
Points: 8, Visits: 67
Thanks all...
I've just done a count and the actual number of rows transferring will be about 3.5 - 4 million rows a day and about 4Gb.

Why do you expect using SSIS will avoid database log file growing?


I was thinking along the lines of when you do an export (ie right click on the DB, go to tasks, exports) that it doesn't fill the log files, so when transformed to an SSIS package it wouldn't either.... or is that a wrong assumption?

You will be better off with SELECT INTO and minimum logging using Simple or Bulk-logged mode


That was why I thought about doing a select into in the first instance, although I have to say I'm now thinking about the entire process in place where the iis log files get imported into the DB in the first place and that there might be a better way to manage the back ups than having to even transfer the data to a different database to back up.
Any thoughts on how to back up 1 days worth of data on a database daily rather than the whole lot every day?
Post #1384612
Posted Wednesday, November 14, 2012 7:20 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 42,470, Visits: 35,541
trowsell (11/14/2012)
Thanks all...
I've just done a count and the actual number of rows transferring will be about 3.5 - 4 million rows a day and about 4Gb.

Why do you expect using SSIS will avoid database log file growing?


I was thinking along the lines of when you do an export (ie right click on the DB, go to tasks, exports) that it doesn't fill the log files, so when transformed to an SSIS package it wouldn't either.... or is that a wrong assumption?


Exports (reading data) doesn't log. Importing (writing data) does, doesn't matter how it's written, it has to be logged.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1384617
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse