Viewing 15 posts - 1,486 through 1,500 (of 4,745 total)
I guess trying to change actual sys.sp_spaceused is not a good idea.
you guess correct 🙂
October 4, 2011 at 9:04 am
Lexa (10/3/2011)
george sibbald (10/3/2011)
use the info from table master.sys.master_files and fileproperty.see http://www.sqlservercentral.com/Forums/Topic1182966-149-1.aspx#bm1183474
Thanks, I'm trying to monitor DB growth at database level not at a file level for all DBs. ...
October 4, 2011 at 2:24 am
the detached files must have come from somewhere, no chance they cannot be replaced by a database backup?
October 3, 2011 at 4:25 pm
use the info from table master.sys.master_files and fileproperty.
see http://www.sqlservercentral.com/Forums/Topic1182966-149-1.aspx#bm1183474
October 3, 2011 at 4:18 pm
I am spoilt by always having sysadmin rights so things like this are never a problem to me, so I might be wrong but it might be file level permissions...
October 3, 2011 at 4:04 pm
certainly the native tools cannot do it and I would be surprised if third party tools can as the database is not in a correct state to be backed up.
September 30, 2011 at 10:57 am
thought you were probably ok with it but didn't want to take the chance, as you say hard to convey tone.
I don't know the emoticon for 'not trying to be...
September 29, 2011 at 3:57 pm
wasn't meaning to have a go Jack, I just read it that the op was after a percentage.
September 29, 2011 at 2:31 pm
Jack Corbett (9/29/2011)
You can do this as well:
SELECT
DF.name,
size,
FILEPROPERTY(DF.name, 'spaceused') AS pages_used
FROM
sys.database_files AS DF
..but that...
September 29, 2011 at 1:16 pm
Fabrizio Faleni (9/29/2011)
September 29, 2011 at 4:14 am
do they by any chance go out of control when you reindex your database?
September 29, 2011 at 3:58 am
Sqlsavy (9/28/2011)
That means once it becomes 8GB RAM I should remove 3GB switch isn't?
no - see my earlier post
September 28, 2011 at 4:54 am
....thanks for feeding back though 🙂
September 27, 2011 at 10:42 am
this is 32 bit yes?.
no point enabling AWE until you have more than 4GB. AWe only enables memory usage above the 4GB line .
The /3Gb switch enables SQL to use...
September 27, 2011 at 10:07 am
Viewing 15 posts - 1,486 through 1,500 (of 4,745 total)