Post reply

Transaction file Growing

  • July 1, 2014 at 4:08 pm

    #296126

    Hi

    I am new to Sql Server Administration activities. I have created Database which is only for staging purpose which means data will be truncated every time before loading into tables.

    I am using Sql Server 2008 R2

    I have created Database using the default options in SSMS and just mentioned the path of the Datafile and transaction file.

    Transaction File size is growing very fast than Datafile. I am aware that there are not much to store in Transaction log when we truncate table. But log file file growing quickly.

    Can you please advise if i need to specify any options while creating database?

    Thanks

    Nag

  • July 1, 2014 at 9:32 pm

    #1726367

    Your database may be in full recovery mode. You should set it to simple recovery mode or start with a full Db backup and then perform a transaction log backup

  • July 2, 2014 at 2:23 am

    #1726402

    Please take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • July 2, 2014 at 3:24 am

    #1726417

    Why is my log full.[/url]

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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