@H_301_1@右键单击sql Server Management Studio的Treeview中的数据库并使其脱机然后选择“删除”选项时,是否将分配给数据库的所有空间释放回o / s文件系统池?
解决方法
如果在删除数据库之前使数据库脱机,则不会从磁盘中删除数据文件.请在线查看本书的这一部分.
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.