sql-server – 在SQL Server Management Studio中删除数据库时,是否所有空间都被释放回O / S?

前端之家收集整理的这篇文章主要介绍了sql-server – 在SQL Server Management Studio中删除数据库时,是否所有空间都被释放回O / S?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
右键单击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.

猜你在找的MsSQL相关文章