It was discovered that a log table was logging too many records in a database and has since been corrected. I am being asked to recover the space from the millions of deleted rows. I do not want to do a shrinkdatabase, but how else can I go about this? The table will not grow as large as it was again anytime in the near future. Should I use shrinkfile?
If it's a one-time event, shrinking the database, or shrinking the file, is no big deal. What happens is people get into a vicious circle of growing, shrinking, growing, shrinking which leads to massive fragmentation on the disk. Doing it one time because of a single event is fine.