|
-
Help!
Hi all:
Please help!
I am getting the following error on a prod database.
Database 'db_name' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
There is sufficient memmory and hard drive space on the server. What is the possible cause of this and how do I fix this?
ndba
-
What do you see in SQL server error log?
Do the database files exist in disk?, check whether the size seems correct?
-
It works!
The files existed and the sizes were good, I just restored the backup to make sure I had a good backup and then I just detached the databse and re attached it. It works fine now. I am not sure what happened there! FYI The data files and log files are on a separate drives.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote