Still having some SQL problems

John Lange ( (no email) )
Wed, 21 May 1997 10:56:35 -0500

HI all and thanks in advance for your input.

Apparantly I have two (with SQL, not including personal) problems.

The first serious and the second because of the first, I can't get the
calls table to reduce. I have a 200MB db for Emerald and it's full. This
seems unusual because Dale sugests a much smaller db in the instructions.

Tried dumping the transaction log and it didn't help.

Here is the Maint. report.

Thanks again

JOhn :}

Microsoft (R) SQLMaint Utility, Version 6.50.240
Copyright (C) Microsoft Corporation, 1995 - 1996

Logged on to SQL Server 'SERVERNAME' as 'sa' (XXXXXXXX)
Starting maintenance of database 'Emerald' on Wed May 21 04:00:01 1997

[1] Check Data and Index Linkage...

The following errors were found:

Table Corrupt: The row number and offset of each row in the page should
have a matching entry in row number table; check this page (page#=82065
row#=4 offset in row number table=374)

Table Corrupt: Row length is inconsistent between the computed row length
and the recorded row length on page; check the following page and row:
pageno=58856 row#=98 computed row length=16 row length on page=18
** Execution Time: 0 hrs, 13 mins, 36 secs **

[2] Check Data and Index Allocation...

** Execution Time: 0 hrs, 1 mins, 45 secs **

[3] Check Text/Image Data Allocation...

** Execution Time: 0 hrs, 0 mins, 1 secs **

[4] Check System Data...

** Execution Time: 0 hrs, 0 mins, 1 secs **

[5] Update Statistics...

** Execution Time: 0 hrs, 1 mins, 13 secs **

[6] Index Rebuild (leaving 10% free space)...

Rebuilding indexes for table 'AccountTypes'
Rebuilding indexes for table 'Actions'
Rebuilding indexes for table 'Aliases'
Rebuilding indexes for table 'CallHistory'
Rebuilding indexes for table 'Calls'
[Microsoft SQL-DMO] Error 1105: [SQL Server] Can't allocate space for
object 'Calls' in database 'Emerald' because the 'default' 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.

** Execution Time: 0 hrs, 0 mins, 41 secs **

[7] Database Backup...
Destination: 'D:\MSSQL\BACKUP\Emerald_db_dump.199705210417'

** Execution Time: 0 hrs, 1 mins, 24 secs **

[8] Delete Old Backup Files...
0 file(s) deleted.

End of maintenance for database 'Emerald' on Wed May 21 04:18:42 1997

SQLMAINT.EXE Process Exit Code: 1 (Failed)

John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers!
608.742.1601 & 6980 2800 New Pinery Road, Suite 10
http://www.palacenet.net/ Portage, WI 53901
http://www.microt.com/

--- __o
--- _-\<,_ FASTEST SERVICE IN TOWN
--- (_)/ (_)