Post reply

question about log file

  • 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

  • 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.

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply