Re: [Emerald] Database Device Expansion errors

Dale E. Reed Jr. ( (no email) )
Thu, 01 Apr 1999 20:45:51 -0800

Adam Greene wrote:
>
> While the action I took allowed the database to accept new data, and enabled a successful Consolidation to be run, things are still not working quite right. For example, the Emerald database used to say it had a total Data Size of 75Mb (the size of the Emerald device and the EmeraldLog device combined). Now it says it has a Data Size of 25Mb (the size of the Emerald device alone) and a Log Size of 70Mb. There is only 1.39Mb of Data Space available. Does this seem right? Should I expand the Emerald Data Device?

You probablu will need to. One thing you should do is run the
checkdb.sql script and then recalculate the size of the DB.

> Also, my SQL "Automated Weekly Task" no longer works, returning the message:
> ------------
> 3/29/99 10:28:33 AM SQLExecutive Warning Task Engine 208 N/A NS SQL Server Scheduled Task: 3, 'Emerald Daily Automated Maintenance' -- Status: Failed
> -- Task Invoked on: 3/29/99 10:26:18 AM -- Message: Process Exit Code 1. ... ** Execution Time: 0 hrs, 0 mins, 22 secs **[4] Delete Old Backup Files...0 file(s) deleted.End of maintenance for database 'Emerald' on Mon Mar 29 10:28:31 1999SQLMAINT.EXE Process Exit Code: 1 (Failed). NOTE: The task was retried the requested number of times (1) without succeeding. The task failed.
> -------------
>
> Finally, when Seagate BackupExec tries to backup the database, I get this error:
> -------------
> 3/29/99 12:36:44 PM Backup Exec Error None 57856 N/A NS An error occurred while executing the following query: "DBCC NEWALLOC(Emerald)".
> OS error message: "".
> DBLIB error message: "General SQL Server error: Check messages from the SQL Server.".
> Server error message: "Extent not within segment: Object 1856009643, indid 1 includes extents on allocation page 13312 which is not in segment 1.".
> -------------
>
> Whew! Any help would be greatly appreciated. Thank you VEEERRRRYYY much.

I would see how it goes after expanding the database and running
the checkdb.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html