Alter failed for Database ‘MFA’. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Unable to open the physical file “F:\databases\MFA.mdf”. Operating system error 5: “5(Access is denied.)”.
Unable to open the physical file “F:\databases\MFA.ldf”. Operating system error 5: “5(Access is denied.)”.
Database ‘MFA’ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
ALTER DATABASE statement failed.
Nonqualified transactions are being rolled back. Estimated rollback completion: 100%. (Microsoft SQL Server, Error: 5120)
I have check the Error Logs in SQL Server instance and the message is shown as below:
Go SQL Server Agent right click Properties, on Advanced tab, in Idle CPU condition check box for Define idle CPU condition, and you can put your average CPU usage (%) and remains below this level (seconds). It should works if not try to detach some databases to increase the free space on disks.