Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Server 2000 Space

5 views
Skip to first unread message

Hardik

unread,
Nov 30, 2008, 5:33:01 AM11/30/08
to
Received the error as below.
Severity: Critical Error
Status: New
Source: SQL Server 2000 Space Analysis:MSSQLSERVER:Database(XXXXX):File
Group:(YYYYY)
Name: SQL Server Database Space
Description: File Group space for XXXXX:YYYYY in instance MSSQLSERVER has
less than the Error threshold of free space:
Threshold: 75 MB
Free Space: 0 MB (0 %)
Agent: grm-0107
Time: 11/29/2008 16:12:48

Anders Bengtsson [MVP]

unread,
Nov 30, 2008, 1:23:13 PM11/30/08
to
Hi Hardik,

What is your question? Do you want to change it? It seems that your database
is out of space, free space = 0% and 0Mb

--
Anders Bengtsson
Microsoft MVP - Operations Manager
Microsoft Certified Trainer (MCT)
http://www.contoso.se

g.mura...@gmail.com

unread,
Jan 8, 2009, 8:16:33 PM1/8/09
to
Hi Anders Bengtsson ,

I receive similar tickets on the sql server.
I tried to check the database size and found the database attribiutes
as unristricted growth and 10% file growth.
i am unable to understand the actual issue?
How can i change the threshold value and verify the space.

Thanks and regards,
Murali

On Nov 30 2008, 1:23 pm, Anders Bengtsson [MVP] <and...@contoso.se>
wrote:


> Hi Hardik,
>
> What is your question? Do you want to change it? It seems that your database
> is out of space, free space = 0% and 0Mb
>
> --
> Anders Bengtsson
> Microsoft MVP - Operations Manager

> Microsoft Certified Trainer (MCT)http://www.contoso.se


>
>
>
> > Received the error as below.
> > Severity:  Critical Error
> > Status:  New
> > Source:  SQL Server 2000 Space
> > Analysis:MSSQLSERVER:Database(XXXXX):File
> > Group:(YYYYY)
> > Name:  SQL Server Database Space
> > Description:  File Group space for XXXXX:YYYYY in instance MSSQLSERVER
> > has
> > less than the Error threshold of free space:
> > Threshold: 75 MB
> > Free Space: 0 MB (0 %)
> > Agent:  grm-0107

> > Time:  11/29/2008 16:12:48- Hide quoted text -
>
> - Show quoted text -

Anders Bengtsson [MVP]

unread,
Jan 9, 2009, 3:18:59 AM1/9/09
to
Hello g.mura...@gmail.com,

You should not have you database on autogrow as this will lock the database
during growing.
When you see the alert in the console you can right-click it and do a override
to change the treshold.
You can also change it under Authoring/Monitors

Anders Bengtsson
Microsoft MVP - System Center Operations Manager
www.contoso.se

0 new messages