MsSQL errors

We are using a program that links to a SQL database on our SBS 2008 server. users are constantly being kicked out of the program with connection errors to the database  on the workstation end such as
"07/21/2014 13:14:17 Error detected by CheckConnection; Error = TCP Provider: The specified network name is no longer available.


Communication link failure
; StateNativeOrigin = State:08S01,Native:64,Origin:[Microsoft][SQL Server Native Client 10.0]
State:08S01,Native:64,Origin:[Microsoft][SQL Server Native Client 10.0]
; RetCode = -1

On the server end, in the event log, i see under application log Event ID 1105 SOURCE:MSSQLSBSMONITORING
"could not allocate space for object 'dbo.eventlog' in database sbsmonitoring because the PRIMARY filegroup is full.
I checked and I have plenty of disk space on all my drives so not sure what is full and how to make more room or if that is even connected to the constant kicking off the programs at the workstation.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
You MUST look at the database in SQL SSMS and allow its MDF to grow more than it is now - that's the message about "PRIMARY filegroup is full"

Open SSMS, connect to the server, expand the databases and right click the one in cause then select Properties.
Select Files from the left menu and click the Autogrow ... button then put the appropriate value so you don't fill up your drive then hit ok. Your PRIMARY database file can now grow by the amount you choose up to that max value.
Scott PletcherSenior DBACommented:
Run this command to get the logical file names:

EXEC sbsmonitoring.sys.sp_helpfile

For every file above that lists a filegroup of "PRIMARY", issue the following command:

ALTER DATABASE sbsmonitoring MODIFY FILE ( NAME = <name_from_command_above>, MAXSIZE = UNLIMITED )

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.