Just following up to see if anybody has a solution to the error I am getting above. How do I dump the transaction log? or can I issue the following command...
Delete from Syslogs
Thanks..
after executing the script, it give me the error below. ANy idea?
Thanks again.
===============================
Msg 1105, Level 17, State 2
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...
OK, I was able to find section 1 which is "with entp mgr".
It is under Server\SQL Server\Configure\Configuration tab
I am confuse about section 2, which is "USE msdb".
Do I use Tool\SQL Query Tool to execute the 2nd section?
Thanks for the help.
Hi,
Below is the error I am getting...it recommend to dump the transaction log...we are running sql 6.5. not so familiar with 6.5, can you send step by step instruction. thanks.
-----------------------------------
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.