Link to home
Start Free TrialLog in
Avatar of jetyun
jetyun

asked on

Error #1105 - 'Syslogs' , 'logsement'

I have this problem when i deleting the tables in the database. The detail of this error r :

"Error #1105 [Microsoft][ODBC SQL Server Driver][SQL Server] Can't allocate space for object 'Syslogs' in database 'CUSTOMER' 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."

I really no idea how to solve this. Do u have any solution on this matter? pls reply me. Thanx.
ASKER CERTIFIED SOLUTION
Avatar of ibro
ibro

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TheSpirit
TheSpirit

Hi,
What Ibro says is correct if you are using SQL7 or SQL2000, but I guess you are on SQL6.5 since you have refs to SYSLOGS, unfortunatly if you are sp_detach_db will not work since it is SQL7 and SQL2000 only. You need to look at the devices that are used by this database and work from there. If the log is placed on a seperate device the file for this device should be expanded and space allocated to that device. If the log and data share the same device just expand this one.
Avatar of jetyun

ASKER

Dear All,
   Wher can I check or view the log file??? Yes, I am using SQL 6.5...
From EM the database properties should allow you to expand the log, however you may need to expand the database device that the log is part of, this is also in EM
Avatar of jetyun

ASKER

sorry for late accepting ur answer.