If file group for perticular database is running out of space then we shrink log files to release space but if during the same time if any backup job same databse is running then system won't let you perform shrink operation since backups is in progress for the same database.
can you please advise then how we can perform shrink in such situation or resolve file group running out of space issue?
asked Jun 30, 2011 at 01:56 AM in Default
If you are finding that your log files are too big, then you might want to consider increasing the frequency of log backups. Shrinking the log files is not a workable option.
Also consider how much data you have and how big the disks are - you might simply be getting to the point where you need to physically increase the disk sizes.
answered Jun 30, 2011 at 02:03 AM
Kev Riley ♦♦
I suggest you to move the log files to other drive to allow a database files to grow.
Other thing is why your log is growing so much and then you have to shrink it. IF you have a FULL recovery mode, then you can lower the interval of periodic log backups to allow reuse of the VLF inside the log.
If you are running in FULL recovery mode and you are not performing regular log backups, then consider whether you need the FULL recovery mode or not. If not, then switch to SIMPLE recovery mode and if you need the full recovery mode, then you should schedule regular log backups which will allow the log file to recycle and will not cause extensive log grow.
In case you are in a SIMPLE recovery mode and the logs grows a lot, then you should analyse what causes that grows, as you are probably manipulating very large amount of data in single transaction. Then you should find such sources and consider to rewrite those parts to work in more convenient way. Eg. do updates of very large amounts on data in multiple batches instead of single batch etc.
hi every one, i am facing the same problem as, 1)Could not allocate space for object in database 'OperationsManager' because the 'PRIMARY' filegroup is roll up. 2)Could not allocate a new page for database 'OperationsManager' because of insufficient disk space in filegroup 'PRIMARY'. 3)file group is running out of space. I apply these command but not resolved the problem.
Plz help me urgent regards. shafiq
answered Jan 17, 2013 at 10:19 AM