Database log file is full?

• cstrati

  SSChasing Mays

  Points: 606

  More actions

  July 10, 2014 at 6:24 pm

  #290879

  Hi,

  I am receiving the below message however when going into my database properties and going into 'File' it's set as either unrestricted growth for the log files or 2097152MB limit and the log files are only taking up about 3gigs.

  [font="Arial Narrow"]Could not allocate new page for database. There are no more pages available in the file group.

  Database log file is full. Back up the transaction log for the database to free up some log space.

  Could not allocate space for ojbect in database because the filegroup is full.[/font]

  Do you know how I can resolve this and give it more space?

  Thanks in advance.

• Grant Fritchey

  SSC Guru

  Points: 398711

  More actions

  July 11, 2014 at 3:49 am

  #1728655

  Please don't cross post, it just confuses the discussion. All answers to this link

  "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