MsSQL errors

Posted on 2014-08-19
Last Modified: 2014-08-28
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.

Question by:raffie613
    LVL 39

    Expert Comment

    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.
    LVL 68

    Accepted Solution

    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 )

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now