October 27, 2005 at 2:08 pm
Hi,
I have a datafile of 20GB, increased it to 40GB. After it's done allocating the space, SQL EM db properties and sp_helpfile shows it's still 20GB, but the OS file has grown to 40GB already.
Any idea? I'm confused.
Thanks!
October 28, 2005 at 10:12 am
EM is not 'real-time', it's more of a 'snap-shot'. Try 'refresh' on 'databases' ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 28, 2005 at 12:49 pm
I agree with Rudy as far as EM, not when it comes to sp_helpfile returning incorrect values.
Please post the directory listing of the data files, sp_helpfile for the database, and the ouput of select * from dbo.sysfiles in this database.
October 28, 2005 at 1:05 pm
Run DBCC UPDATEUSAGE ('dbname'). Replace dbname with the actual database name.
-SQLBill
October 28, 2005 at 1:10 pm
Excellent catch SQLBill ... I guess my 'senility' lost the last half of the problem posted ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 28, 2005 at 1:12 pm
Are you sure that will help in this case? I have only used that to fix invalid reports from sp_spaceused and anything that uses dbo.sysindexes. sp_helpfile is reporting from dbo.sysfiles.
October 31, 2005 at 7:15 am
I use it all the time to 'fix' Enterprise Manager and have it reflect the updated information.
-SQLBill
October 31, 2005 at 9:19 am
We are not talking about EM we are talking about a system table in the user db!
November 1, 2005 at 11:26 am
Quote from original poster: SQL EM db properties and sp_helpfile shows it's still 20GB
That says SQL EM (Enterprise Manager).
I still say the poster needs to run DBCC UPDATEUSAGE.
-SQLBill
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply