SQL 1105 What To Do? Please Help Me
Aug 7, 2002Situation:
SQL cluster with 90 Gyga in raid 5 and 2 web server
all NT and SQL 7.0
1)Enterp. Man.
-General:
Size: 2.369MB
Space available: 163.47MB
Data space
Used
Free
Total
-Space Allocated
--------------------------------------------------------------------------------
PBSPP001 2.168.69MB
2.168.69MB
--------------------------------------------------------------------------------
Transaction log space 32.59MB(used) 167.40MB (Free)
199.99MB
- Space available
Directory of F:MSSQL7Data
19/07/02 11.41 <DIR> .
19/07/02 11.41 <DIR> ..
17/07/02 13.22 21.954.560 archivio_Data.MDF
17/07/02 13.22 1.048.576 archivio_Log.LDF
02/08/02 10.05 38.862.848 BCSPP001_Data.MDF
06/08/02 10.05 3.932.160 BCSPP001_Log.LDF
17/07/02 13.22 8.388.608 BCSPT001_Data.MDF
17/07/02 13.22 7.798.784 BCSPT001_Log.LDF
17/07/02 13.22 241.958.912 demo.mdf
17/07/02 13.22 32.243.712 demo_log.ldf
08/02/00 04.16 1.048.576 distmdl.ldf
08/02/00 04.16 3.145.728 distmdl.mdf
17/07/02 13.22 209.715.200 ISSC_Data.MDF
17/07/02 13.22 13.893.632 ISSC_Log.LDF
17/07/02 13.22 9.240.576 master.mdf
17/07/02 13.22 1.310.720 mastlog.ldf
17/07/02 13.22 786.432 model.mdf
17/07/02 13.22 786.432 modellog.ldf
05/08/02 11.54 12.320.768 msdbdata.mdf
17/07/02 13.22 786.432 msdblog.ldf
17/07/02 13.22 1.048.576 northwnd.ldf
17/07/02 13.22 3.080.192 northwnd.mdf
06/08/02 12.56 2.501.443.584 PBSPP001.mdf
05/08/02 18.12 209.715.200 PBSPP001_log.ldf
24/07/02 09.20 2.274.099.200 PBSPT001.mdf
24/07/02 09.20 132.120.576 PBSPT001_log.ldf
19/07/02 11.42 435.290.112 PIPYP001.mdf
05/08/02 21.30 9.437.184 PIPYP001_log.ldf
19/07/02 10.07 435.290.112 PIPYT001_Data.MDF
26/07/02 14.12 6.086.656 PIPYT001_Log.LDF
17/07/02 13.22 1.310.720 pubs.mdf
17/07/02 13.22 516.096 pubs_log.ldf
05/08/02 15.23 84.541.440 TEMPDB.MDF
23/07/02 21.02 53.608.448 TEMPLOG.LDF
34 File(s) 6.756.810.752 bytes
78.937.866.240 bytes free
F:MSSQL7Data>
- Program error
- ------------------------------------------------*
- * Inizio Esecuzione 06/08/02 10.59.32
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Clienti
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Clienti nuovi
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Clienti riassegnati
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Clienti estinti
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TWKCLI
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TEDTPF
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Clienti
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Clienti nuovi
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Clienti riassegnati
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TWKCLI
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TEDSPF
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Massa C/C
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Massa Titoli (no obbl.)
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Portafoglio Titoli (no obbl.)
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Massa e Portafoglio Titoli (obbl.)
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Massa PCT
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Massa Polizze
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TWKMAS
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Valore Intermediato Titoli
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TWKVIA
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Classificazione Portafoglio Titoli
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TEDTPR
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TEDTKI
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Drop TWKFPA, NEWMAS, NEWMIA, NEWVIA
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Creare consolidated TWKMAS, TWKMIA, TWKVIA
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TWKFPA
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TEDTPA
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Insert TEDSPA
- *--------------------------------------------------*
- *-------------------------------------------------*
- * Insert TEDTTI
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Errore comando SQL: insert into TEDTTI select a.NDGCOD, TITCOD, CONVERT(DATETIME,CONVERT(CHAR(10),GETDATE(),120)) AS RIFDAT, CLTCOD, SUM(SCNQTA) AS SCNQTA, SUM(SCNIMP) AS SCNIMP from twktit a, tstanp b where a.ndgcod = b.ndgcod group by a.NDGCOD, TITCOD, CLTCOD
- * SQLCODE: 1105
- * SQLDESC: Could not allocate space for object 'TEDTTI' in database 'PBSPP001' because the 'PRIMARY' filegroup is full.
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Programma terminato con errori *
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Fine Esecuzione 06/08/02 11.22.42
- *--------------------------------------------------*
- *--------------------------------------------------*
- * Durata Elaborazione 1390 secondi
- *--------------------------------------------------*
This error appear after a db shrink, before the shrink appened at TWKCLI insert
-sp_helpdb
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ ----------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PBSPP001 2368.69 MB D91IPB01sqladmin 8 Nov 21 2000 select into/bulkcopy, trunc. log on chkpt.
I can send the sql Enterprise Manager images