Server: Msg 9002, Level 17, State 6, Line 1

  • Hi Everyone,

    I receive this msg. when trying to run my DTS pkg.

    Server: Msg 9002, Level 17, State 6, Line 1

    The log file for database '<database name>' is full. Back up the transaction log for the database to free up some log space.

    Is there anythin I can do at my end or do I have to get my DBA to do something?

    Thanks,

    Kay Dee

     

     

  • If you can (a) run a backup, (b) free up space on the log drive <assuming your DB has autogrowth for log's - which it should>, then you can do something.

    If you can only transact against the database (sql statements), then you must either wait until after the enxt scheduled backup, or else get hold of your DBA

  • Thanks for your reply.

    Our DBA has dealt with the issue.

    Everything works okay now.

     

     

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

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