Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Message log is full and cannot connect

Author  Topic 

geossl
Yak Posting Veteran

85 Posts

Posted - 2004-01-08 : 20:52:24
Dear All,
A dialog has prompted stating that the server message log is full and any connection to server cannot be initated.
After closing the dialog box, the connection works again!


There are a lot of free disk space.

Is there any problem of the server?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-09 : 12:09:35
Are you referring to the transaction log being full? If so...

What database recovery model is your database set to? If FULL, are you performing backups of the transaction log?

If you aren't referring to the transaction log being full, then what is the exact error message?

Tara
Go to Top of Page

geossl
Yak Posting Veteran

85 Posts

Posted - 2004-01-10 : 01:53:44
No. I mean the SQL Server message log....
Go to Top of Page

jeroena
Yak Posting Veteran

76 Posts

Posted - 2004-01-10 : 18:37:34
Can it be the Windows eventlog or maybe the log files in the MSSQL\LOG folder?

Jeroen.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-12 : 12:11:44
Please explain what a message log is. The SQL Server Error Log, Windows Event Log... Message log is not a term that is used in SQL Server. Are we even talking about SQL Server?

Tara
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-01-12 : 12:13:58
Please post the exact error text, including error number if possible.


-ec
Go to Top of Page
   

- Advertisement -