transaction log, bulk-logged recovery model, DBAs

  • I just tried creating a stored proc on a database on our development server. The recovery model is set to "Bulk Logged".

    Error message: The transaction log for database 'MyDatabase' is full due to 'LOG_BACKUP'.

    I can see that the database was last backed up two weeks ago, and last log backup was some days before that.

    As a developer, I don't have access to setup backup jobs or anything like that. There's a DBA who is supposed to handle this.

    Thoughts?

  • Can you ask the DBA to modify the database recovery model or to set up log backup?

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • I will probably request that she change the model to "simple".

  • i_am_moose (11/15/2016)


    I will probably request that she change the model to "simple".

    Before you do that, be sure that you don't need point-in-time recovery for that database. (Ultimately the DBA will know and should be available to advise.)

  • Point your DBA at this: http://www.sqlservercentral.com/articles/books/94938/

    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
  • Gail, thank you!!

Viewing 6 posts - 1 through 5 (of 5 total)

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