When upgrading Uniprint I receive an error message "You need 42 GB available free space"

When upgrading Uniprint I receive an error message "You need 42 GB available free space"


This issue is caused when the database is unable to grow because it believes there is no space available.

The solution is to rebuild indexes within the Pharos Database:

- Download MSDE Manager (30 day free tool). This will allow you re-index the complete database. Make sure you stop all of the Pharos services before completing this task.

http://www.soft32.com/download_11260.html

- Run the following SQL script, which automatically re-indexes all tables in a database. Make sure you stop all of the Pharos services before completing this task.

USE pharos <-- Enter the name of the database you want to re-index

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT table_name FROM information_schema.tables

WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT 'Reindexing' + @TableName

DBCC DBREINDEX(@TableName,' ',70)

FETCH NEXT FROM TableCursor INTO @TableName

END

CLOSE TableCursor

DEALLOCATE TableCursor