sql-server - 当在 SQL Server Management Studio 中删除数据库时，所有空间是否都会释放回操作系统？

Question

当右键单击 SQL Server Management Studio 树形 View 中的数据库并将其脱机，然后选择“删除”选项时，分配给该数据库的所有空间是否都会释放回操作系统文件系统池？

Answer 1

如果在删除数据库之前使数据库脱机，数据文件将不会从磁盘中删除。请在线查看本书的这一部分。

http://msdn.microsoft.com/en-us/library/ms178613.aspx

Dropping a database deletes the database from an instance of SQL Server and deletes the physical disk files used by the database. If the database or any one of its files is offline when it is dropped, the disk files are not deleted. These files can be deleted manually by using Windows Explorer. To remove a database from the current server without deleting the files from the file system, use sp_detach_db.