sql server (alternate): 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

(arijitchatterjee123@yahoo.co.in) writes:
[quoted text, click to view]

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

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