db out of space

When I try to backup a table with a query such as:
SELECT * INTO dbo.SiteNotes_COPY FROM dbo.SiteNotes
I am getting an error indicating my database is out of space. Note that the
error message refers to my active database, *not* the tempdb as I have seen
in various other posts both on this board (e.g. "tempdb 2005 out of space" b
y
Dan D.) and on others.
Here is my error message:
"Msg 1101, Level 17, State 2, Line 1
Could not allocate a new page for database 'ProdDB' because of insufficient
disk space in filegroup 'PRIMARY'. Create the necessary space by dropping
objects in the filegroup, adding additional files to the filegroup, or
setting autogrowth on for existing files in the filegroup."
From database properties:
--Autogrowth was set to "By 1MB, unrestricted" so I increased that to 5MB
but I still have the same problem. The initial size is listed as 4096MB
From table properties:
--The table in question occupies 22MB (81,000 rows).
From Windows Explorer:
--The .mdf file size is shown as 4.00GB so it is clearly a growth boundary
issue.
--My disk has plenty of space (44GB)
Other operations with some other large tables have shown the same error
message.
Is there a cure for this malady?
(System: I am running SqlServer2005 Express on WinXP Pro SP2.)SQL Server Express has a hard limit of 4GB per database. We could
have hoped for a more informative messages, but that is the limit you
have encountered.
Roy Harvey
Beacon Falls, CT
On Tue, 12 Jun 2007 16:11:00 -0700, michael sorens
<m_j_sorens@.newsgroup.nospam> wrote:

>When I try to backup a table with a query such as:
> SELECT * INTO dbo.SiteNotes_COPY FROM dbo.SiteNotes
>I am getting an error indicating my database is out of space. Note that the
>error message refers to my active database, *not* the tempdb as I have seen
>in various other posts both on this board (e.g. "tempdb 2005 out of space"
by
>Dan D.) and on others.
>Here is my error message:
>"Msg 1101, Level 17, State 2, Line 1
>Could not allocate a new page for database 'ProdDB' because of insufficient
>disk space in filegroup 'PRIMARY'. Create the necessary space by dropping
>objects in the filegroup, adding additional files to the filegroup, or
>setting autogrowth on for existing files in the filegroup."
>From database properties:
>--Autogrowth was set to "By 1MB, unrestricted" so I increased that to 5MB
>but I still have the same problem. The initial size is listed as 4096MB
>From table properties:
>--The table in question occupies 22MB (81,000 rows).
>From Windows Explorer:
>--The .mdf file size is shown as 4.00GB so it is clearly a growth boundary
>issue.
>--My disk has plenty of space (44GB)
>Other operations with some other large tables have shown the same error
>message.
>Is there a cure for this malady?
>(System: I am running SqlServer2005 Express on WinXP Pro SP2.)|||Thank you for solving my mystery!