Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details.
This error is very common for any database administrator who are handling more databases in a single instance. It will leads to suspect the database most of the time.
Fix / Solution:
Step 1: if the drive is specifically assigned to Log Files and Log drive was full, clear the drive space by shrinking the log space of other databases which occupied more log space.
Step 2: ALTER DATABASE [Database name] SET ONLINE
Step 3: If possible add more drive space by adding new hard drive to server.
Step 4: Increase the Database log size to more or set to Unlimited grow.
Step 5: Find out if the account which is trying to access the database has enough permission to access the database.
Step 6: Configure one maintenance job for backup log.
Step 2: ALTER DATABASE [Database name] SET ONLINE
Step 3: If possible add more drive space by adding new hard drive to server.
Step 4: Increase the Database log size to more or set to Unlimited grow.
Step 5: Find out if the account which is trying to access the database has enough permission to access the database.
Step 6: Configure one maintenance job for backup log.
No comments:
Post a Comment