CODEWITHSUNDEEP
sql-server-2008
Conrad Jagger
Conrad Jagger

Reputation: 643

SQL Server - Does dropping table will recover the used space

Need advise:

Database: HR (initial size:250mb)

In this we got two tables

Table 1: Employee (100mb) Table 2: Employeebackup (125mb)

So as per above, we have still 25mb space available as per size we set for the database.

Now we drop the Employeebackup table, so will sql server recover the space (which is 125mb) and now making 150mb as available space.

Regards

Upvotes: 1

Views: 101

Answers (1)

Gareth
Gareth

Reputation: 2791

Yes, it should do. There may be some delay while SQL Server figures it out and does the necessary housekeeping in the background though.

If you want to recover the space on the disk in addition to recovering space available to the database, you'd then have to shrink the database.

You might also want to consider asking these kinds of questions on https://dba.stackexchange.com/ which is specifically for database related Q & A.

Upvotes: 1

Related Questions