Transaction file Growing

  • 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

  • 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

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