September 17, 2003 at 10:44 am
I was not sure what is the difference between CurrentSize and UsedPages in the output for DBCC ShrinkFile. I have a log file which is 4 gigs big and below is the output.
132559304256559304256
On taking a transaction log backup, the backup size was just 570 KB. Can someone explain.
September 17, 2003 at 1:14 pm
Take a look at Books Online. It gives you a nice table to explain it's output.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
September 19, 2003 at 8:39 pm
That is what is confusing me. BOL says that output is in following order,.
DBID, Fileid,CurrentSize,MinimumSize, UsedPages,EstimatedPages. and definitions are as under.
CurrentSize : The number of 8-KB pages the file currently occupies.
UsedPages : The number of 8-KB pages currently used by the file.
The values which i'm getting for currentsize and UsedPages is as under.
CurrentSize 559304
Usedpages 559304
What is the difference between the two ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply