question about log file

• hinata

  SSC Journeyman

  Points: 76

  More actions

  September 30, 2007 at 9:36 am

  #198519

  Hi,

  I wonder why when i use query analyzer to copy tables from a database to another database the size of log file does not increase but if i use dts to do so it will increase the size.Can anyone tell?

  Thanks!!

  Regards

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  September 30, 2007 at 10:47 am

  #737539

  How are you doing the copies?

  Sounds like a select * into from query analyser which will just log the extent allocations (ish).

  Maybe dts is doing a create table and logged inserts.

  You can use the profiler to capture the statements executed and that should give you a clue.

  
  Cursors never.
  DTS - only when needed and never to control.
  

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  Follow

  September 30, 2007 at 9:01 pm

  #737588

  If you add a table to the database, data or not, the log data increases. This a logged event and something is written even in simple mode.

  I'd like to hear more about how you copy the tables and if these are to/from the same servers.