PRIMARY filegroup is full?

Error Message
- Task reported failure on execution (SQL DTS). Could not allocate space for
object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
filegroup is full.
SQL Server Info
- SQL Server 2000 Standard Edition
- Intel Xeon 3.06 GHz
- 60 GB HDD
Database Properties
- Size 2,426.69 MB
- Space available 1,047.60 MB
- Data files is automatically grow file and unrestricted file growth
- Transaction Log is automatically grow file and unrestricted file growth
- Filegroups is PRIMARY
Please help.
Sam wrote:
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate
> space for object 'TABLE_EMPLOYEE' in database 'Employee' because the
> 'PRIMARY filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file
> growth
> - Filegroups is PRIMARY
> Please help.
Could you be running a very large task using DTS that is causing the log
file and data file growth to fill up that last gigbyte of space? Can you
move the log to another drive with more space? How big is the log now?
Can you backup the database or truncate the log file if it's too large?
David G.
|||The data file (employee.mdf) is 1,872 MB.
The transactiona log (employee.ldf) is 556MB.
"David G." <david_nospam@.nospam.com> wrote in message
news:eGF$l40gEHA.3348@.TK2MSFTNGP12.phx.gbl...
> Sam wrote:
> Could you be running a very large task using DTS that is causing the log
> file and data file growth to fill up that last gigbyte of space? Can you
> move the log to another drive with more space? How big is the log now?
> Can you backup the database or truncate the log file if it's too large?
> --
> David G.
>
|||sometime files doesn't grow fast enough, so you get this "database is full" message. I suggest you
pre-allocate storage (also good for performance reasons).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate space for
> object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file growth
> - Filegroups is PRIMARY
> Please help.
>
|||Notice that SQL Server 2000 is only permitted 2GB per database.
Therefore, the database shrinked and able to update via SQL DTS.
Could it add more data files into single database so that each of it consist
2GB?
Please advise.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> sometime files doesn't grow fast enough, so you get this "database is
full" message. I suggest you
> pre-allocate storage (also good for performance reasons).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
for[vbcol=seagreen]
growth
>
|||SQL Server support about 1 million TB size for database. Each file can be 32 TB.
However, MSDE has max size of 2GB for data (transaction log not included). Sam doesn't appear to be
running MSDE as data size is already over 2GB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> Notice that SQL Server 2000 is only permitted 2GB per database.
> Therefore, the database shrinked and able to update via SQL DTS.
> Could it add more data files into single database so that each of it consist
> 2GB?
> Please advise.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> full" message. I suggest you
> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> for
> growth
>
|||I'm using SQL Server 2000 Standard Edition and how much the size of database
(MDF)?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
> SQL Server support about 1 million TB size for database. Each file can be
> 32 TB.
> However, MSDE has max size of 2GB for data (transaction log not included).
> Sam doesn't appear to be
> running MSDE as data size is already over 2GB.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
>
|||In SQL Server 2000 Standard Edition, max size for an mdf file is 32 TB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:eBe7WmBhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I'm using SQL Server 2000 Standard Edition and how much the size of database
> (MDF)?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
>