Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql Server Table Fills Disk

Status
Not open for further replies.
OnDeBanks

OnDeBanks

IS-IT--Management
Feb 21, 2003
14
IE
Hello,
A table on my SQL 2000 server got so big it filled the disk on the server. I deleted all the rows and shrank the database but the file is still taking up all the disk space.

What else can I do to reduce the size of the file?

Thanks..............
 
Sort by date Sort by votes
try truncating the table and the your shrink db

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
258
pjw001
pjw001
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
241
CodeWell
CodeWell
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
194
dhookom
dhookom
Ikatiemarie
  • Locked
  • Question
SQL Server 2008 SP_Send_dbmail
Replies
0
Views
502
Ikatiemarie
Ikatiemarie
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
194
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top