x

file group is running out of space

Hello,

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?

rgds,

more ▼

asked Jun 30, 2011 at 01:56 AM in Default

avatar image

pits
830 89 92 95

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Jun 30, 2011 at 02:03 AM

avatar image

Kev Riley ♦♦
66.1k 48 63 81

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jun 30, 2011 at 02:07 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

Well said Kev..frequent shrinking of log file is not at all a good idea....

Jun 30, 2011 at 02:47 AM Manikreddy

that really good idea to set database from FULL recovery mode to simple , there after shrink the database,but if log shipping or db mirroring is running what about the jobs then

Jun 30, 2011 at 02:54 AM ramesh 1

As I wrote, if there is no reason for FULL recovery model, switch to SIMPLE, otherwise keep FULL and make more frequent backups of the log as laso @Kev stated. The VLFs will be reused after log backup.. Of course in case then the data were processed by eventual log shipping and mirroring.. But if the log grows because accumulating data for mirroring or log shipping, than I would investigate, why the log data are not consumed by mirroring or log shipping and are accumulating in log.

Jun 30, 2011 at 04:20 AM Pavel Pawlowski

If file group primary is running out of space,what maximum impact it will have ? will it cause in to disk crash?

Oct 12, 2011 at 08:10 AM pits
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Jan 17, 2013 at 10:19 AM

avatar image

msocp
0

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x43
x25

asked: Jun 30, 2011 at 01:56 AM

Seen: 7620 times

Last Updated: Jan 17, 2013 at 10:36 AM

Copyright 2017 Redgate Software. Privacy Policy