Post reply

logfile use

  • May 4, 2012 at 5:27 am

    #268377

    while ruuunig a ssis package we are geeting the Executing the query "sp_....'" failed with the following error:

    transaction log for database 'A" is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly

    i have checked the log file size it is having freespace .

    can any one help me

  • May 4, 2012 at 5:48 am

    #1483473

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    Probably what happened is that the SSIS package filled the log, failed and rolled back, then something partially cleared the log (or grew it), so by the time you checked there was free space.

    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

  • May 4, 2012 at 5:53 am

    #1483475

    do i need to increase the log file size or do i need to put file to unrestricted size.

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

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