Size of database devices reported in NT 2

[JezzBrooks]

I've encountered this before but cannot remember the details: essentially, Enterprise manager gets to the point where it reports the wrong size for both data and log devices , I sort this with CHECKTABLE and UPDATEUSAGE. EM then shows the correct size, however, in NT, explorer shows the a size close to the allocated space rather than the actual space used - is this meant to happen or should explorer just show the size the device actually uses?

I am currently about to upgrade from 6.5 to 2000 but because of the device reported in explorer there is insufficient space to do the upgrade.

please help

 

[tlbroadbent]

Windows Explorer will always show the actual size of the database device or file. This is true for all versions of SQL Server. Enterprise Manager shows the size of the database which may be less than the size of the file. Unlike SQL 6.5, SQL 2000 will allow the device or file to grow and shrink dynamically. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[JezzBrooks]

Thanks - I needed to hear it from someone who knows - I can now pursue why NT is showing the wrong size - don't suppose you've got any pointers.

cheers

 

[tlbroadbent]

Perhaps, I wasn't clear in my explanation or I misunderstand you. You said, "EM then shows the correct size, however, in NT, explorer shows the a size close to the allocated space rather than the actual space used."

Windows NT Explorer will show the allocated space for the device. In SQL 6.5 the device size is fixed. It must always be large enough to hold the database. The actual database size can never be larger than the device size and is usually smaller. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[JezzBrooks]

Doh! - I thought there was room for misinterpretation in my explanation but I thought I'd post that reply and see if you clarrified it or not. It's crystal clear now.

many thanks

 

[dbmsguy]

just as a btw,

you can also get the size of the database used/allocated by running

dbcc showfilestats

this is my experience will not require updateusage to be run and is quite quick. it will report space in 'blocks' which in my case is 16K Paul

http://www.dbmsguy.com

 

[tlbroadbent]

Paul,

Thanks for the info. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.