Pablo wrote:
Usually when the t-log becomes full, in the windows event log appears a message telling to check the log_reuse_wait_desc column of the sys.databases view, in order to know the reason because the t-log space can't be reused (a t-log truncation can't be done)
That's right! I have a lot of these Messages. If i look for these Information it shows (see below table). log_reuse_wait = 0 and log_reuse_desc = NOTHING
The only two things left for me is:
- re-install vCenter and hope that solves the problem = > hope... lol!!! :smileycry:
- install a non-express Version of SQL Server to see if a T-Log with let's say 20GB is enough... => i think the only thing this changes is that the T-Log is now 20GB but still gets full and still crashes my vCenter
| name | database_id | recovery_model | recovery_model_desc | log_reuse_wait_desc | source_database_id | create_date | compatibility_level | collation_name | user_access | user_access_desc | is_read_only | is_auto_close_on | is_auto_shrink_on | state | state_desc | is_in_standby |
| master | 1 | 3 | SIMPLE | NOTHING | NULL | 08.04.2003 09:13 | 100 | Latin1_General_CI_AS | 0 | MULTI_USER | 0 | 0 | 0 | 0 | ONLINE | 0 |
| tempdb | 2 | 3 | SIMPLE | NOTHING | NULL | 19.03.2014 14:36 | 100 | Latin1_General_CI_AS | 0 | MULTI_USER | 0 | 0 | 0 | 0 | ONLINE | 0 |
| model | 3 | 3 | SIMPLE | NOTHING | NULL | 08.04.2003 09:13 | 100 | Latin1_General_CI_AS | 0 | MULTI_USER | 0 | 0 | 0 | 0 | ONLINE | 0 |
| msdb | 4 | 3 | SIMPLE | NOTHING | NULL | 02.04.2010 17:35 | 100 | Latin1_General_CI_AS | 0 | MULTI_USER | 0 | 0 | 0 | 0 | ONLINE | 0 |
| RSA | 5 | 3 | SIMPLE | NOTHING | NULL | 30.11.2012 15:59 | 100 | Latin1_General_CI_AS | 0 | MULTI_USER | 0 | 1 | 1 | 0 | ONLINE | 0 |
| VIM_VCDB | 6 | 3 | SIMPLE | NOTHING | NULL | 30.11.2012 16:24 | 100 | Latin1_General_CI_AS | 0 | MULTI_USER | 0 | 1 | 0 | 0 | ONLINE | 0 |
| VIM_UMDB | 7 | 3 | SIMPLE | NOTHING | NULL | 28.01.2013 16:16 | 100 | Latin1_General_CI_AS | 0 | MULTI_USER | 0 | 0 | 0 | 0 | ONLINE | 0 |