Re: Primary File Group Full

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 12:24:26 -0400

This is for tempdb, but much of it applies to all DBs
http://www.aspfaq.com/2446 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Gary" <Gary@discussions.microsoft.com> wrote in message
news:95030BF0-28D9-4D26-AE82-07F685DFA63B@microsoft.com...
> I'm getting an error when I'm copying data into a table.  The error is
saying the the Cannot allocate space.  Primary File Group Is Full.  I've
been unable to find any information on the error.  Can someone please tell
me what this means and how to go about correcting it?
>
> Thanks

Relevant Pages

  • Re: SQL Server Clustering DB Advice
    ... > I have question about setting up DBs on Clustered environment. ... Now how does setting up clustering work on SQL End?? ... > dbs go to the central server?? ... > for tempdb or other system DBS?? ...
    (microsoft.public.sqlserver.programming)
  • Re: tempdb full. When do you get this error ?
    ... exec sp_helpdb tempdb ... > can extend and is unlimited, the tempdb is in simple mode. ... >> (Reverse address to reply.) ...
    (microsoft.public.sqlserver.server)
  • Re: How to know what is filling UpTempdb
    ... (Reverse address to reply.) ... "Sudha Reddy" wrote in message ... > my tempdb was 10MB and it has grown to 250mb in a have day ... > without restarting the sql server. ...
    (microsoft.public.sqlserver.server)
  • Re: question about tempdb
    ... (Reverse address to reply.) ... "joe" wrote in message ... > CREATE TABLE permission denied in database 'tempdb'. ...
    (microsoft.public.sqlserver.programming)