I encountered the following error when Connecting db today:
SQL SERVER — FIX: Error 945 Database cannot be opened to capacity files or disk space. See the SQL SERVER Error log for details
The first intuition is the DBF permission issue, a check sure enough…
Due to lack of space
Also moved the DBF file below
and attached the
SQL template as follows:
CREATE DATABASE [ALS_LFE] ON PRIMARY
( NAME = N’DXXXXXXXXXXXXXXXXX’, FILENAME = N’DXXXXXXXXXXXXXXXXX.mdf’ , MAXSIZE = XXXXKB, FILEGROWTH = XXXXKB )
LOG ON
( NAME = N’DXXXXXXXXXXXXXXXXX_log’, FILENAME = N’DXXXXXXXXXXXXXXXXX.ldf’ ,MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
FOR ATTACH
GO[@more@]
From “ITPUB blog” link: http://blog.itpub.net/8337095/viewspace-1033527/, if you want to reprint, please indicate the source, otherwise will be investigated for legal responsibility.
Reproduced in: http://blog.itpub.net/8337095/viewspace-1033527/
Read More:
- Solution of insufficient memory space or desktop stack in GX works2
- Error in installing torch vision or pilot on Linux or Jetson nano: the headers or library files could not be found for JPEG
- Insufficient space in the root directory causes the state of the managed server to become FAILED_NOT_RESTARTABLE
- [screen recording] an error is reported in the screenrecord command: inaccessible or not found
- Solve the problem of non system disk or disk error, replace and strike any key when ready
- Non system disk or disk error
- The computer can’t turn on ERROR: NO BOOT DISK HAS BEEN DETECTED OR THE DISK HAS FAILED
- How to clean up the disk space of Linux server
- Cannot read configuration file due to insufficient permissions
- How to search files or folders in Ubuntu
- Insufficient table space ORA-00604 unable to extend table SYS.AUD by 8192
- Solve to the cache because there was insufficient free space available after evict
- U disk installation Linux system could not boot, / dev / root does not exist and the identified hard disk space is not available
- When the MAC M1 uiautomatorviewer is opened, it displays blank or reports an error
- Linux view folder size, remaining disk space (DU / DF)
- The media could not be loaded, either because the server or network failed or because the format is
- Oracle can’t start the database due to deleting DBF file by mistake
- Some index files failed to download. They have been ignored, or old ones used instead
- Tomcat Error: because there was insufficient free space available after evicting expired cache entries
- The transaction log for database ‘xxxx’ is full due to AVAILABILITY_REPLICA error message in SQL Ser…