Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Database Size Limiting

 
   Database Forums (Home) -> Setup RSS
Next:  Fragmented Indexes  
Author Message
Dan112

External


Since: Aug 24, 2004
Posts: 69



(Msg. 1) Posted: Tue Feb 26, 2008 6:23 pm
Post subject: Database Size Limiting
Archived from groups: microsoft>public>sqlserver>setup (more info?)

Hello. Is there a way in SQL Server 2005 Standard to forcibly limit a
particular database in size? I would like to be able to set a max limit, and
be alerted when the database gets close (say, 90%), just like an Exchange
mailbox would.

Is this possible? Thanks.

 >> Stay informed about: Database Size Limiting 
Back to top
Login to vote
Andrew J. Kelly

External


Since: Sep 01, 2003
Posts: 975



(Msg. 2) Posted: Tue Feb 26, 2008 11:34 pm
Post subject: Re: Database Size Limiting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Sure, in the database properties there is a property for max size. You have
to do the monitoring for size on your own though.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Dan" wrote in message

> Hello. Is there a way in SQL Server 2005 Standard to forcibly limit a
> particular database in size? I would like to be able to set a max limit,
> and
> be alerted when the database gets close (say, 90%), just like an Exchange
> mailbox would.
>
> Is this possible? Thanks.

 >> Stay informed about: Database Size Limiting 
Back to top
Login to vote
Dan112

External


Since: Aug 24, 2004
Posts: 69



(Msg. 3) Posted: Wed Feb 27, 2008 12:33 am
Post subject: Re: Database Size Limiting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Sorry, I don't see this setting. When I open the properties of a database,
there's nothing about max size.

"Andrew J. Kelly" wrote:

> Sure, in the database properties there is a property for max size. You have
> to do the monitoring for size on your own though.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "Dan" wrote in message
>
> > Hello. Is there a way in SQL Server 2005 Standard to forcibly limit a
> > particular database in size? I would like to be able to set a max limit,
> > and
> > be alerted when the database gets close (say, 90%), just like an Exchange
> > mailbox would.
> >
> > Is this possible? Thanks.
>
>
 >> Stay informed about: Database Size Limiting 
Back to top
Login to vote
Aaron Bertrand [SQL Serve

External


Since: Jun 15, 2005
Posts: 632



(Msg. 4) Posted: Wed Feb 27, 2008 4:04 am
Post subject: Re: Database Size Limiting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

> Sorry, I don't see this setting. When I open the properties of a
> database,
> there's nothing about max size.

You need to look at the properties of the individual database files.
 >> Stay informed about: Database Size Limiting 
Back to top
Login to vote
Dan112

External


Since: Aug 24, 2004
Posts: 69



(Msg. 5) Posted: Wed Feb 27, 2008 4:04 am
Post subject: Re: Database Size Limiting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Ahh, perfect. One last question. Is it possible to lock down the database
size and log files to a combined maximum, or do I need to do each separately?

"Aaron Bertrand [SQL Server MVP]" wrote:

> > Sorry, I don't see this setting. When I open the properties of a
> > database,
> > there's nothing about max size.
>
> You need to look at the properties of the individual database files.
>
>
 >> Stay informed about: Database Size Limiting 
Back to top
Login to vote
Andrew J. Kelly

External


Since: Sep 01, 2003
Posts: 975



(Msg. 6) Posted: Wed Feb 27, 2008 1:51 pm
Post subject: Re: Database Size Limiting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

They need to be supplied separately. But I wonder what the goal of this is?
If you set a max size and you forget to increase the file size and it runs
out your database activity will stop. If you let it autogrow then it will
keep going. Even though you never want autogrow to actually kick in it is
there for a safety purpose. The Max sizes should only be used to prevent the
disk from completely filling up.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Dan" wrote in message

> Ahh, perfect. One last question. Is it possible to lock down the
> database
> size and log files to a combined maximum, or do I need to do each
> separately?
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
>> > Sorry, I don't see this setting. When I open the properties of a
>> > database,
>> > there's nothing about max size.
>>
>> You need to look at the properties of the individual database files.
>>
>>
 >> Stay informed about: Database Size Limiting 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Database size - Good Morning, I am attempting to create a 10GB database with a 5GB log file using MSSQL Server 2000 (Standard), with Windows 2000 Server as the operating system. The d: in question has 66GB of file space, and yet I am getting this error : Server: Msg..

database size limits - We are running close to 2GB over here on our database (1.85GB exactly). We are using SQL Server 2000 Personal Edition. Personal edition allows databases to be up to 4GB, am I right? ..

Database size from 8gb to 40gb - Hi... i have a database that original size is 8GB, but for some reason it change size to 40gb... I try compact it to original size but I Can't... Is SQL 2000, Model Recovery "Simple" I make a query, this query show me the size of all tables ...

Database size growth - Hi I have just moved a database from an sql 2000 server to a 2005 server. When I moved the database it was 7.5Gb in size and it was only growing very slowly at about 100MB a month or so. Now a couple of weeks later the database has grown to 38GB with ...

Restore Database Size - I have made a copy of a SQL Server 2000 database for testing puposes. Most of the data in the original database is in one gigantic table. To reduce the size of the test database, I have truncated the table in the test database. I also did a "s...
   Database Forums (Home) -> Setup All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]