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.
"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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear All,
Wher can I check or view the log file??? Yes, I am using SQL 6.5...
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
ASKER
sorry for late accepting ur answer.
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.