|
Posted by convoluted on October 21, 2009, 1:57 am
Please log in for more thread options
The error appears to indicate that you may have reached the max limit on your
SQL database - SQL Express will support up to 4GB - MSDE is limited to 2GB.
The log file may also have grown to a large size if the database recovery
mode is not set to simple - check these out. The log file can be reduced in
size by shrinking the db and reindexing - but the problem will recur if you
don't alter the db to set its recovery mode to simple - sample script:
ALTER DATABASE yourdatabase SET RECOVERY SIMPLE
If using full SQL run this against the MODEL database to prevent future
stores exported from HQ having this issue (new databases created in full SQL
inherit this setting from the MODEL db) - hope this helps.....
"RicoTowers" wrote:
> ---------------------------
> Headquarters Client
> ---------------------------
> Time: 10/20/2009
>
>
>
> <<ExecuteCommand>> Error -2147217900: Could not allocate space for object
> 'dbo.Journal'.'PK_Journal' in database 'ALOMACHQ' because the 'PRIMARY'
> filegroup is full. Create disk space by deleting unneeded files, dropping
> objects in the fileg
> ---------------------------
> OK
> ---------------------------
>
|