[Emerald] Database Device Expansion errors

Adam Greene ( (no email) )
Mon, 29 Mar 1999 16:43:11 -0500


I am having a little problem with my Emerald database. I am running =
Emerald 2.1.8, Radius 2.2, SQL 6.5 on a 233 MHz server with 128 MB RAM. =
I have about 950 MBR's.

Yesterday, while running a Call History Consolidation, I got the =
message, "Error deleting old records table!" Sure enough, the Event =
Viewer said:
3/28/99 1:16:02 PM MSSQLServer Error Server 17060 N/A NS Error : 1105, =
Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'Emerald' because =
the 'logsegment' segment is full. If you ran out of space in Syslogs, =
dump the transaction log. Otherwise, use ALTER DATABASE or =
sp_extendsegment to increase the size of the segment.=20

Since Emerald would not update the database and since users began =
calling in to say, "I can't log on!" because Emerald thought they were =
still online, and since it was Sunday (no response expected from mailing =
list), I decided to try expanding the EmeraldLog device "on the fly."

I expanded the size of the EmeraldLog Database Device from 50 to 70Mb. =
Then I opened the Emerald Database and clicked "Expand." I selected =
"EmeraldLog" as the Log Device, specified 20MB as the size (20Mb=3Dthe =
amount I increased the device), and clicked "Expand Now." =20

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?

Also, my SQL "Automated Weekly Task" no longer works, returning the =
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.=20

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.".=20

Whew! Any help would be greatly appreciated. Thank you VEEERRRRYYY =


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