We’ve had an error
Autogrow of file ‘MyDatabase_dat’ in database ‘MyDatabase’ was cancelled by user or timed out after 30078 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
I was able to fix the issue using:
ALTER DATABASE MyDatabase
MODIFY FILE ( NAME = MyDatabase_dat, size=5000MB)
We should follow the best practices from MSDN article “Considerations for the “autogrow” and “autoshrink” settings in SQL Server”
In particular, use alerts or monitoring programs to monitor file sizes and grow files proactively. To reduce the possibility of running out of space, you can monitor the Performance Monitor counter SQL Server: Databases Object :Data File(s) Size (KB) and set up an alert for when the database reaches a certain size.