Alter failed for Database – Unable to open the physical file


Alter failed for Database ‘MFA’.  (Microsoft.SqlServer.Smo)
——————————
ADDITIONAL INFORMATION:

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:

errorlog

————-

Solution:

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.

Advertisements

About Buja Atdhe

CEO of the platform
Gallery | This entry was posted in Error directory, Technical descriptions and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s