Why....'PRIMARY' filegroup is full????

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • arijitchatterjee123@yahoo.co.in
    #1

    Why....'PRIMARY' filegroup is full????

    Dear All,
    I am new in MS Sql Server.I am facing a error
    "'PRIMARY' filegroup is full".I went through the all previous
    submitions.But still this error is coming.Please help me out.
    I have Installed Microsoft Sql Server 2000. It was working perfectly.

    Present Database Details
    =============== =========
    ..mdf size 3.91 GB from Explorer and from
    Enterprise Manager Space Allocated 4007 MB
    ------------------------------------------
    ..LDB size 3.79 GB from Explorer and from
    Enterprise Manager Space Allocated 177 MB
    -----------------------------------------
    Auto Incementation is On
    -----------------------------------------
    File Growth in Percentage 10
    -----------------------------------------
    Remaining Space in Drive 7 GB
    =============== ==========

    But at the time of importing data getting error
    =============== ============
    'PRIMARY' filegroup is full
    =============== ============

    What should be the reason?Thanks in advance
    Regards
    Arijit Chatterjee

    Tags: None
    • Erland Sommarskog
      #2
      Re: Why....'PRIMARY ' filegroup is full????

      (arijitchatterj ee123@yahoo.co. in) writes:[color=blue]
      > I am new in MS Sql Server.I am facing a error
      > "'PRIMARY' filegroup is full".I went through the all previous
      > submitions.But still this error is coming.Please help me out.
      > I have Installed Microsoft Sql Server 2000. It was working perfectly.
      >
      > Present Database Details
      >============== ==========
      > .mdf size 3.91 GB from Explorer and from
      > Enterprise Manager Space Allocated 4007 MB
      > ------------------------------------------
      > .LDB size 3.79 GB from Explorer and from
      > Enterprise Manager Space Allocated 177 MB
      > -----------------------------------------
      > Auto Incementation is On
      > -----------------------------------------
      > File Growth in Percentage 10
      > -----------------------------------------
      > Remaining Space in Drive 7 GB
      >============== ===========
      >
      > But at the time of importing data getting error
      >============== =============
      > 'PRIMARY' filegroup is full
      >============== =============[/color]

      Judging from the data you presented here, I see no reason why it should
      occur.

      But there are a few details missing:
      o Check that the data file is set to unrestricted growth. If the file
      set to a max of 4007 MB, it can autogrow 10% from 3.91 GB.
      o Check the error message for which database the error occurs in. The
      problem could be with tempdb.



      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server SP3 at
      Microsoft SQL Server
      http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
      Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

        Comment

        • arijitchatterjee123@yahoo.co.in
          #3
          Re: Why....'PRIMARY ' filegroup is full????

          Thanks for your reply. I didn't get this point at the time of fixing .
          I added another data file and that is working perfectly without any
          error. And I made that in group.
          Thangs and Regards
          Arijit Chatterjee

            Comment

            Previous template Next
            Working...