How to force space allocation to a SS2000 DB?

I have to force a space allocation to a DB file in order to stop a Diagnostic Manager alert which states that the database is over 80% full. Now, I don't think this alert is rational, nor do I think it is useful in any way but that's the way it goes. My only option is to allocate more space to the DB so that the space used will fall below 80% so the alert will stop being issued.

So, can you tell me how to force a space allocation on an existing db file?

Thanks,

Michael

Hi Michael,

You have to define the initial size for your file as big as you need. You can do it with the MS SQL Server Manager Studio, Databases --> mydatabase --> right clic --> properties --> files

You can do it like this code sample

Code Snippet

USE [master]

GO

ALTER DATABASE [mydatabase] MODIFY FILE ( NAME = N'mydatabase_file_name', SIZE = 10240KB )

GO

Hope it helps.

Laurent

How to find logged errors and not-logged erros

Alert don't fire if error is not logged.
How to find logged errors and not-logged erros '
Errors in severity level 20 to 25 are always logged?
ThanksFor logged errors, look in the application log and the SQL
Server error log. Messages that aren't logged you won't find
anywhere. They aren't logged so they aren't recorded
anywhere.
Fatal severity level errors (20 -25), are logged in the
error log and the application log.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:
>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||And one other thing to add...they are stored in the
sysmessages table in master. The dlevel indicates if they
are logged or not.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:
>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||Wich is the value for logged error?
Is 128 ?
Thanks
"Sue Hoegemeier" wrote:
> And one other thing to add...they are stored in the
> sysmessages table in master. The dlevel indicates if they
> are logged or not.
> -Sue
> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
> favero@.discussions.microsoft.com> wrote:
> >Alert don't fire if error is not logged.
> >How to find logged errors and not-logged erros '
> >Errors in severity level 20 to 25 are always logged?
> >
> >Thanks
>|||Yup...128 is logged.
-Sue
On Wed, 16 Mar 2005 07:17:04 -0800, "andrea favero"
<andreafavero@.discussions.microsoft.com> wrote:
>Wich is the value for logged error?
>Is 128 ?
>Thanks
>"Sue Hoegemeier" wrote:
>> And one other thing to add...they are stored in the
>> sysmessages table in master. The dlevel indicates if they
>> are logged or not.
>> -Sue
>> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
>> favero@.discussions.microsoft.com> wrote:
>> >Alert don't fire if error is not logged.
>> >How to find logged errors and not-logged erros '
>> >Errors in severity level 20 to 25 are always logged?
>> >
>> >Thanks
>>

How to find logged errors and not-logged erros

Alert don't fire if error is not logged.
How to find logged errors and not-logged erros ?
Errors in severity level 20 to 25 are always logged?
Thanks
For logged errors, look in the application log and the SQL
Server error log. Messages that aren't logged you won't find
anywhere. They aren't logged so they aren't recorded
anywhere.
Fatal severity level errors (20 -25), are logged in the
error log and the application log.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros ?
>Errors in severity level 20 to 25 are always logged?
>Thanks
|||And one other thing to add...they are stored in the
sysmessages table in master. The dlevel indicates if they
are logged or not.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros ?
>Errors in severity level 20 to 25 are always logged?
>Thanks
|||Wich is the value for logged error?
Is 128 ?
Thanks
"Sue Hoegemeier" wrote:

> And one other thing to add...they are stored in the
> sysmessages table in master. The dlevel indicates if they
> are logged or not.
> -Sue
> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
> favero@.discussions.microsoft.com> wrote:
>
>
|||Yup...128 is logged.
-Sue
On Wed, 16 Mar 2005 07:17:04 -0800, "andrea favero"
<andreafavero@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Wich is the value for logged error?
>Is 128 ?
>Thanks
>"Sue Hoegemeier" wrote:

How to find logged errors and not-logged erros

Alert don't fire if error is not logged.
How to find logged errors and not-logged erros '
Errors in severity level 20 to 25 are always logged?
ThanksFor logged errors, look in the application log and the SQL
Server error log. Messages that aren't logged you won't find
anywhere. They aren't logged so they aren't recorded
anywhere.
Fatal severity level errors (20 -25), are logged in the
error log and the application log.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||And one other thing to add...they are stored in the
sysmessages table in master. The dlevel indicates if they
are logged or not.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||Wich is the value for logged error?
Is 128 ?
Thanks
"Sue Hoegemeier" wrote:

> And one other thing to add...they are stored in the
> sysmessages table in master. The dlevel indicates if they
> are logged or not.
> -Sue
> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
> favero@.discussions.microsoft.com> wrote:
>
>|||Yup...128 is logged.
-Sue
On Wed, 16 Mar 2005 07:17:04 -0800, "andrea favero"
<andreafavero@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Wich is the value for logged error?
>Is 128 ?
>Thanks
>"Sue Hoegemeier" wrote:
>