Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Database size limitation
iceraider_12
#1 Posted : Thursday, September 09, 2010 5:36:53 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 3
Location: NJ
The error logs on our server are filling up frequently. We are seeing the following messages over and over again:

2010-09-08 18:37:38.64 spid53 Error: 1827, Severity: 16, State: 1.
2010-09-08 18:37:38.64 spid53 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
2010-09-08 18:37:38.71 spid53 Error: 1105, Severity: 17, State: 2.
2010-09-08 18:37:38.71 spid53 Could not allocate space for object 'dbo.tblerrors'.'PK__TsysErrors__408F9238' in database 'lansweeperdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

We have free space on our server so I don't think it's a space issue. I know SQL express has a 4GB limit. Can we upgrade to regular SQL to get past this limit? Also, what could be trying to use so much space in our database. We're pretty much configured with the default settings although we did configure a custom file search for a specific application that we're looking for.
Lansweeper
#2 Posted : Thursday, September 09, 2010 6:28:12 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 9,982
If you are using SQL express you need to upgrade to another SQL version to bypass the 4GB limit.

How many computers are you scanning?
iceraider_12
#3 Posted : Thursday, September 09, 2010 7:39:43 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 3
Location: NJ
We have about 3000 computers on our network. No, that's not a typo, 3000.
Lansweeper
#4 Posted : Friday, September 10, 2010 9:26:22 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 9,982
I suggest upgrading to SQL workgroup version, this version don't has the database limit.
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba