SEO

#1 (**permalink**) 02-29-2008, 07:27 AM

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

#2 (**permalink**) 02-29-2008, 07:28 AM

(arijitchatterjee123@yahoo.co.in) writes:
> 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
>===========================

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@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

#3 (**permalink**) 02-29-2008, 07:28 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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