How to add FILEGROUP?

Error Message
--
CREATE / ALTER DATABASE failed because the resulting cumulative database
size would exceed your licensed limit of 2048 MB per database.
Error 1105 Severity 17 State 2
Could not allocate space for object 'INVENTORY_OUT' in database 'INVENTORY'
because the 'PRIMARY' filegroup is full.
Inquiry
--
How to add SECONDARY filegroup into this database so that it will not exceed
the licensing limit?
Please advise.Sorry, you won't be able to do it that way. It's the database that's
limited to 2 GB, not each individual filegroup. Find some data to trim
away, archive, or move to another database.
http://www.aspfaq.com/
(Reverse address to reply.)
"Sam" <cybersam88@.hotmail.com> wrote in message
news:#1E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||You must be using MSDE which has a 2GB per db so it doesn't matter how many
files or filegroups you have. You need to upgrade to a licensed version to
go above 2GB per DB.
Andrew J. Kelly SQL MVP
"Sam" <cybersam88@.hotmail.com> wrote in message
news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||I'm using SQL Server 2000 Standard Edition.
I just wonder whether it's really license issue or database per filegroup
issue?
If license issue, then how much SQL Server 2000 Standard Edition could cater
max size of database?
If filegroup, I had been created some which each one max size is 2GB?
Please advise.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> You must be using MSDE which has a 2GB per db so it doesn't matter how
> many
> files or filegroups you have. You need to upgrade to a licensed version
> to
> go above 2GB per DB.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> 'INVENTORY'
> exceed
>|||> I'm using SQL Server 2000 Standard Edition.
Judging by that error messages, you are indeed running MSDE. Can you post ba
ck the result from:
SELECT @.@.VERSION
SE support 32TB per database file, and sum of about 1,000,000 TB totally for
the db.
Your solution is not creating more files or filegroups. It is elsewhere.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl..
.
> I'm using SQL Server 2000 Standard Edition.
> I just wonder whether it's really license issue or database per filegroup
> issue?
> If license issue, then how much SQL Server 2000 Standard Edition could cat
er
> max size of database?
> If filegroup, I had been created some which each one max size is 2GB?
> Please advise.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
>|||Thanks.
I checked that my server is running MSDE.
I wonder how can it MSDE override MS SQL Standard Edition.
What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Judging by that error messages, you are indeed running MSDE. Can you post
> back the result from:
> SELECT @.@.VERSION
> SE support 32TB per database file, and sum of about 1,000,000 TB totally
> for the db.
> Your solution is not creating more files or filegroups. It is elsewhere.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
>|||Perhaps you have both MSDE and SQL Server. I.e., two instances installed?
I don't think that you can upgrade MSDE to a "regular" SQL Server, as they h
ave different
installation programs.
So, unless you are indeed working against the incorrect instance, you are lo
oking at backup, remove
MSDE, install SQL Server, and restore. There are lots of issues to consider
here (stuff in system
databases like logins etc, collations etc). Search KB for suitable keywords.
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7wEVsChEHA.3964@.TK2MSFTNGP12.phx.gbl..
.
> Thanks.
> I checked that my server is running MSDE.
> I wonder how can it MSDE override MS SQL Standard Edition.
> What's best advise? Uninstall MS SQL and re-install MS SQL Standard Editio
n?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
>