| Author |
multiple datadbase files
|
|
| viktor 2002-11-27, 6:23 am |
| SQL Server 7 SP4
I have a database with 3 different primary mdf files.
And the properties of the database shows this:
file - space allocated
....Data1.mdf - 13144
....Data2.mdf - 3000
....Data3.mdf - 11156
does somebody know because the size of Data2 doesn't grow in size?
thanks, victor.
| |
| Wayne Snyder 2002-11-27, 9:23 am |
| SQL will put data in each of the files using a 'proportional fill'
methodology until the file becomes full... Is the file at maxsize with
autogrow off?
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corp (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"viktor" <victor@pminformatica.net> wrote in message
news:O97cEnglCHA.2260@tkmsftngp07...
> SQL Server 7 SP4
>
> I have a database with 3 different primary mdf files.
>
> And the properties of the database shows this:
>
> file - space allocated
> ...Data1.mdf - 13144
> ...Data2.mdf - 3000
> ...Data3.mdf - 11156
>
> does somebody know because the size of Data2 doesn't grow in size?
>
> thanks, victor.
>
>
| |
| Quentin Ran 2002-11-27, 4:24 pm |
| I thought one database can have only one primary file, isn't it true?
If that's true, then what you are looking at are primary files from
different databases, and you would not expect they grow abreast.
"viktor" <victor@pminformatica.net> wrote in message
news:O97cEnglCHA.2260@tkmsftngp07...
> SQL Server 7 SP4
>
> I have a database with 3 different primary mdf files.
>
> And the properties of the database shows this:
>
> file - space allocated
> ...Data1.mdf - 13144
> ...Data2.mdf - 3000
> ...Data3.mdf - 11156
>
> does somebody know because the size of Data2 doesn't grow in size?
>
> thanks, victor.
>
>
| |
| Tibor Karaszi 2002-11-28, 4:23 am |
| .... pr perhaps someone named the other (non-primary) files ".mdf", which IMO is a bad move.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Quentin Ran" <quentin.ran@gcserv.com> wrote in message news:e4wTGGmlCHA.1568@tkmsftngp07...
> I thought one database can have only one primary file, isn't it true?
>
> If that's true, then what you are looking at are primary files from
> different databases, and you would not expect they grow abreast.
>
> "viktor" <victor@pminformatica.net> wrote in message
> news:O97cEnglCHA.2260@tkmsftngp07...
> > SQL Server 7 SP4
> >
> > I have a database with 3 different primary mdf files.
> >
> > And the properties of the database shows this:
> >
> > file - space allocated
> > ...Data1.mdf - 13144
> > ...Data2.mdf - 3000
> > ...Data3.mdf - 11156
> >
> > does somebody know because the size of Data2 doesn't grow in size?
> >
> > thanks, victor.
> >
> >
>
>
| |
|
|
I'm using SQL Server 7.0 SP4
O.S. Windows NT 4.0 SP6a
configuration for all the files:
* automatic grow is set
* ratio = 150Mb.
* file growth this limited: 15000
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
|
|
This is a SAP database. SAP manage all the installation.
I have other systems with the same configuration without this problem.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
|
|
I'm sorry, but I don't understand the answer
all the files form an only database, I have had an error when writing
database names:
> > ...Data1.mdf - 13144
> > ...Data2.ndf - 3000
> > ...Data3.ndf - 11156
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Tibor Karaszi 2002-11-28, 8:23 am |
| Seems more reasonable. Perhaps one file was created with a smaller size and then expanded?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"vik f" <anonymous@devdex.com> wrote in message news:#XJVChtlCHA.2592@tkmsftngp02...
>
>
> I'm sorry, but I don't understand the answer
>
> all the files form an only database, I have had an error when writing
> database names:
>
> > > ...Data1.mdf - 13144
> > > ...Data2.ndf - 3000
> > > ...Data3.ndf - 11156
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
| |
| viktor 2002-11-28, 11:23 am |
| all the databases were initially created with 3Gb
And the SQL Server grows it automatically.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se>
escribió en el mensaje news:O1Ny#LulCHA.2032@tkmsftngp02...
> Seems more reasonable. Perhaps one file was created with a smaller size
and then expanded?
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "vik f" <anonymous@devdex.com> wrote in message
news:#XJVChtlCHA.2592@tkmsftngp02...
> >
> >
> > I'm sorry, but I don't understand the answer
> >
> > all the files form an only database, I have had an error when writing
> > database names:
> >
> > > > ...Data1.mdf - 13144
> > > > ...Data2.ndf - 3000
> > > > ...Data3.ndf - 11156
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>
>
|
|
|
|