November 15, 2016 at 8:01 am
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?
November 15, 2016 at 8:07 am
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/
November 15, 2016 at 9:54 am
I will probably request that she change the model to "simple".
November 16, 2016 at 1:46 am
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.)
November 16, 2016 at 2:12 am
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
November 16, 2016 at 7:54 am
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