sql server new users: Database Size -- sql server new users

Database Size

Microsoft
7/26/2006 4:20:21 PM

sql server new users:

I have a 20GB database and i recently delete a 2GB table from it, but still
it shows as 20GB database. I have done a backup on both transaction log and
..data file but it didn't help.

any idea how can i free up that 2GB space?

Thanks
Hooman

Re: Database Size

Arnie Rowland
7/26/2006 4:59:05 PM

Check Books on Line for
DBCC shrinkdatabase and DBCC shrinkfile

You need to do both.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

[quoted text, click to view]