July 10, 2014 at 6:31 pm
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.
July 11, 2014 at 3:49 am
It sounds like either the disk is full, or you have a transaction that's so big that it's going to fill the disk and/or the filegroup.
"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
July 11, 2014 at 10:34 am
- Add a second log file.
- To find out what is filling the transaction log
USE [DBNAME];
DBCC OPENTRAN;
- check log backups
- if you have replication, check the log reader is running.
- check index maintenance, you may have a big index rebuilding.
July 14, 2014 at 3:19 am
Have you taken any log backups? It's not clear from your post.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply