Skip to Content
0
Former Member
Jun 09, 2010 at 01:27 PM

How to get unused space in SQL SERVER in OS level

284 Views

Hi ,

We have ECC 6.0 system on Windows 2003 and SQL SERVER 2005 database. There were hugh number of spools request deleted by us.

Now DB02 is showing this :

Number of files 5

Total Size [MB] 402,900

Allocated [MB] 302,727

Free [MB] 100,173

We want 100GB free space in OS level that is inside the SQL server .The affected table was TST03 .

Is there any procedure / document to recover this space in OS level ?

Thanks

Mukul