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

今天連db結果遇到如下錯誤：

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details

第一直覺就是dbf的許可權問題，一查果然。。。。

由於空間不夠

還順便把dbf檔案移動了下
再attach上
sql模板如下：

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@]