Monday, March 12, 2012

Multiple databases

I'm developing a website in a hosted environment and using SQL server 2000.
The hosting company restricts the file growth to 100mb. Because of the number
of views I have several system tables have caused the size to exceed the
100mb. To increase the capacity I have to setup another database (size max
100 mb) then a 3rd and so on.
This is new territory for me and I'm not sure how to set up multiple files
across the databases. Is this the area of filegroups and can multiple
databases share one set of system tables? How do I do this?
Always learning hobbyist.
Wouldn't it be easier to find a new web hosting firm that doesn't limit file
size to 100Mb? If it is possible for you to do this, let me know and I can
pass you some info I have on a company that I know the owner of.
"Merv Harvey" wrote:

> I'm developing a website in a hosted environment and using SQL server 2000.
> The hosting company restricts the file growth to 100mb. Because of the number
> of views I have several system tables have caused the size to exceed the
> 100mb. To increase the capacity I have to setup another database (size max
> 100 mb) then a 3rd and so on.
> This is new territory for me and I'm not sure how to set up multiple files
> across the databases. Is this the area of filegroups and can multiple
> databases share one set of system tables? How do I do this?
> --
> Always learning hobbyist.
|||Rolaaus, I agree 100mb is a bit lousy and you are absolutely right. I expect
the DB to grow to gb's eventually and 100mb files will certainly be out of
the question. For now I will do it once (for the learning). If the site
eventually makes any $$$$ I will look a dedicated hosting.
"rolaaus" wrote:
[vbcol=seagreen]
> Wouldn't it be easier to find a new web hosting firm that doesn't limit file
> size to 100Mb? If it is possible for you to do this, let me know and I can
> pass you some info I have on a company that I know the owner of.
> "Merv Harvey" wrote:
|||File groups is not about size restriction. You could add files to a database
(.ndf) and you could then use file groups to logicall groups this files
together.
As for the shared system file, i don't have an idea at this moment.
Cheers
Gill
..
you start with a mdf file and ndf. create you user tables in the ndf file
rather then mdf. . when it becomes 100mb
"Merv Harvey" <MervHarvey@.discussions.microsoft.com> wrote in message
news:DB4EA409-4259-47B1-92E9-61A880185564@.microsoft.com...
> I'm developing a website in a hosted environment and using SQL server
> 2000.
> The hosting company restricts the file growth to 100mb. Because of the
> number
> of views I have several system tables have caused the size to exceed the
> 100mb. To increase the capacity I have to setup another database (size max
> 100 mb) then a 3rd and so on.
> This is new territory for me and I'm not sure how to set up multiple files
> across the databases. Is this the area of filegroups and can multiple
> databases share one set of system tables? How do I do this?
> --
> Always learning hobbyist.

No comments:

Post a Comment