July 10, 2002 at 12:00 pm
Hello everyone,
I just tried to shrink the database and log files with the "reorganize database" and "shrink database files" options checked. What happened is that my free space before the shrink was 520MB and after the shrink, it is now 260MB. What should I do? And why did the shrink acquire more space instead of "shinking?"
July 10, 2002 at 12:08 pm
What version of SQL Server are you on? Also, did your log file grow? SQL Server 7 and 2000 handle truncating the log file differently is the reason I ask the version.
Steve Jones has a script posted that will forcibly shrink the transaction log:
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 10, 2002 at 1:32 pm
Its version 2000. The data files grew, I guess someone loaded some data while shrinking? It could be. I'll ask everyone to see what they have done today.
July 10, 2002 at 7:45 pm
You may also need to truncate the log before doing the shrink to kill the virtual logs internal to the file.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 11, 2002 at 3:39 pm
Probably not the same thing as your question, but I have noticed that after a shrinkdatabase, the sp_helpdb size goes down, and often the sp_spaceused reserved size goes up!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply