Thank for the information.

To keep this post updated I have finally managed to make my optimization job runs correctly, the main problem was of course the size of the filegroup...

I fact the maintenance plan has been created by the application that use this db so I have not created or modifying anything.

I far as I know, the db is...

Thanks,

So even if the datafile for the data fill the disk (in the case that I have set the unrestricted option) I still have an option to shrink this file....

Thanks for your reply Kenneth,

Well, I can set the unrestricted growth option of course but my worry here is that I really can't know how much the database will grow...

Hi,

I have applied some settings to the database and maintenance plan according to the advices you gave me :

- For the database, I have set the transaction log to...

Thanks Carl,

So you tell me that:

- It is better for me to remove the shrinking option (the Remove unused space from database file option in fact)

- And then find the...

Thanks Gerg,

Do you know a way to have the option to use DBCC INDEXDEFRAG instead of DBCC DBREINDEX in the maintenance plan?