Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL error in log file - help

Posted on 1999-01-07
2
Medium Priority
?
273 Views
Last Modified: 2011-09-20
Hello all,
I´m getting the following error in errolog file in my Sql 6.5:
Can't allocate space for object 'Syslogs' in database 'msdb' 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 dont know what to do?
Can anybody help me? and tell me what to do?
My hard disk is almost full cause this message is increasing the size of error log file.

thank you very much.

Ramiro
0
Comment
Question by:ramiro
2 Comments
 
LVL 2

Accepted Solution

by:
formula earned 800 total points
ID: 1092529
Your logsegement of your database is full:

1) Dump the transaction log as follows:
   DUMP TRANSACTION DBNAME WITH NO_LOG (where DBNAME is your DB)
2) Review the size of the logsegment of your database, you may need to increase it. Typically it should be 25% of your data segment.
3) You may also wish to change your database option to truncate log on checkpoint, so the log is truncated when a transaction completes.

0
 

Author Comment

by:ramiro
ID: 1092530
Great !
Thank you for your help!
I´m a network administrator and i dont know anything about sql administration.

Have a nice day.
Ramiro Rodrigues
r.rodrigues@wang.com.br
Sao Paulo - Brasil
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question