Geek asks and answers

When the database is deleted in SQL Server Management Studio, does all the space go back to O / S?

When the database in Treeview for SQL Server Management Studio right-clicked and disabled, and then the Delete option was selected, is all the space allocated for the database released back to the o / s file system pool?

+5
source share
2 answers

If you delete the database offline before it is deleted, the data files will not be deleted from the disk. Please read this section of books online.

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

SQL Server , . , , . Windows. , sp_detach_db.

+9

. , , (, ), , . , . ( ). , . , 5 .

, , .

+2

More articles:


All Articles