Thanks, currently we do have own DiskspaceCheck sql job to monitor the disk space.
So we set it to unrestricted.
But I see some people are using restricted method.
I am curious if it is set to restricted size and if it is full, what will happen, does it generate any errors or an alert and notifiy DBA, how is this alert set up?
You said the database will become to readonly, is it automatically change it readonly mode?