September 28, 2004 at 12:56 pm
Hi
I have a scheduled job that runs on my server everyday from 2100, and it ends about 2330. I have noticed that the database increase in size during this job, not to mention that it allocates alot of free space and it keeps holding that free space after the job ends.
Thus I have to shrink the database after this job. No problem, but there has to be away around this?
I use scheduled shrink right after the job ends, but can I shrink while the job run?
My shrink settings:
- max free space in files after shrink: 99%
- shrink file to [minimum]
Should I use some other settings? i.e. truncate free space from the end of file.
ps! cross post to forums: general and backups
Best regards
Dan
September 28, 2004 at 2:12 pm
u say jobs, what type of job is that.
September 28, 2004 at 2:12 pm
u say jobs, what type of job is that.
September 28, 2004 at 7:45 pm
One possibility for the growth is that you are running DBCC DBREINDEX on one or more large tables. If so, the growth is unavoidable, since SQL Server needs the space to temporarily store the data/index pages.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply