Enterprise Manager is EVIL.
-----Original Message-----
From: Meg Hardy [mailto:[Email Address Removed] Thursday, September 05, 2002 4:57 AM
To: LazyDBA.com Discussion
Subject: RE: File Sizes
Hello again,
I should have tried harder the first time!! Figured it out. Size in
sysfiles is measured in 8KB pages. So this is exactly the same figure now,
as I get from File Manager. Enterprise Manager is still different to both
of these.... I asume Ent Manger is wrong!
Thanks Anyway.
Meg
-----Original Message-----
From: Meg Hardy
Sent: Thursday, September 05, 2002 10:49 AM
To: SQLDBA (E-mail)
Subject: File Sizes
Hi All,
I am very confused, so any help will be well apreciated!
I am writing a script that monitors data and log file sizes and will email
me when there is a change. To get the current size of the files, I was
using select size from sysfiles in each database to get the sizes. I
thought this was correct. Then I look at the actual size of the files on
file manager and the numbers are very different. Then I looked at Ent
Manager and they are completely different again. Does anyone know what is
the best way to find the REAL size of data and log files?
Thanks
... confused Meg
**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily of Mondial Assistance (UK) Ltd. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.
If you have received this email in error please notify the IT support desk by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message. Please then delete this email and destroy any copies of it. Thank you.
Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ
Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered office as above
**********************************************************************
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
MS Sql Server LazyDBA home page