Re: How to add FILEGROUP?

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 08:37:09 +0200

> I'm using SQL Server 2000 Standard Edition.

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...
> 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...
> >> 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.
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: How to add FILEGROUP?
    ... I'm using SQL Server 2000 Standard Edition. ... I just wonder whether it's really license issue or database per filegroup ... If license issue, then how much SQL Server 2000 Standard Edition could cater ... If filegroup, I had been created some which each one max size is 2GB? ...
    (microsoft.public.sqlserver.server)
  • Re: Processor Based License Model
    ... >> Maybe for databases what we really need is a license that permits X ... >> of transactions per seccond to be processed by the database. ... > SQL Server license. ... > Man would I like to have something like this for Rdb. ...
    (comp.os.vms)
  • Re: Quick Question on SQL Server 2005 Express
    ... I wondered if we need any type of license to use Management Tools on a non-licensed machine so I asked to the Server and Tools Product Manager of Microsoft Turkey, whose name is Selma Karaca, I had met her on several Microsoft seminars which are held here in Istanbul... ... Server tools or technologies installed must have a valid SQL Server license. ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Quick Question on SQL Server 2005 Express
    ... I wondered if we need any type of license to use Management Tools on a non-licensed machine so I asked to the Server and Tools Product Manager of Microsoft Turkey, whose name is Selma Karaca, I had met her on several Microsoft seminars which are held here in Istanbul... ... Server tools or technologies installed must have a valid SQL Server license. ... Notification Services Client Components ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Backup/restore
    ... is the primary file and that the filegroup is not the primary filegroup? ... DBCC SHRINKFILE (File1, EMPTYFILE) ... ALTER DATABASE MyDB ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.server)
Loading