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.
| Author |
Topic |
|
hspatil31
Posting Yak Master
182 Posts |
 Posted - 2009-02-06 : 01:28:03
|
| Dear All,I have one database in SQL Server 2005. In that many tables are available. When i right click on one table for Open Table that time it gives following error. Can anybody suggest me how solve it ?Error is:The event log file is full (SQLEditors)Thanks and RegardsHarish Patil |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-06 : 02:05:45
|
| I assume that the DB is in full recovery and you're not backing up the log. If it's a production database (data loss not permitted) then set up regular log backups. If it's a dev database switch to simple recovery.Please read through this - http://www.sqlservercentral.com/articles/64582/--Gail ShawSQL Server MVP |
 |
|
|
mbourgon
Starting Member
6 Posts |
Posted - 2011-12-29 : 16:54:36
|
| Gail, are you talking about event logs, or the database log? |
|
|
|
|
|
|
Regarding log file full.