Re: database size
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 01/22/05
- Previous message: Yih-Yoon Lee: "Re: Migrating NT4/SQL7 to 2003/SQL2000"
- In reply to: Bernie V: "database size"
- Next in thread: Bernie V: "Re: database size"
- Reply: Bernie V: "Re: database size"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 22 Jan 2005 10:39:26 -0800
Your database size will still be limited by the size of the disk.
The space available value just means that there is 1.05 MB that has already
been allocated to the database that hasn't been used, but it doesn't mean
that no more space could be allocated as needed. Your unrestricted file
growth means unlimited up to the space available on the disk.
-- HTH ---------------- Kalen Delaney SQL Server MVP www.SolidQualityLearning.com "Bernie V" <bernd.vantyghem@pandoradotbe> wrote in message news:%233%23UsKIAFHA.1400@TK2MSFTNGP11.phx.gbl... > Hi group, > > I have a question about the database size. > When I check the properties of my database in enterprise Manager I see: > size: 24.50 MB > space available: 1,05 MB > > I'd like to have a no limit size database. > These are the settings in the data files tab: > near file name: space allocated 5 MB > - automatically grow file (by percent 10) > - unrestricted file growth > > Are these settings ok to have an unlimited database filesize ? > > Thx in advance > > grz > > Bernie V > > > -- > http://www.djberniev.be >
- Previous message: Yih-Yoon Lee: "Re: Migrating NT4/SQL7 to 2003/SQL2000"
- In reply to: Bernie V: "database size"
- Next in thread: Bernie V: "Re: database size"
- Reply: Bernie V: "Re: database size"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
