Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space

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[@[email protected]]

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: