Reply to Message

View discussion in a popup

Replying to:
the_xploit
Contributor
Contributor

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

namedatabase_idrecovery_modelrecovery_model_desclog_reuse_wait_descsource_database_idcreate_datecompatibility_levelcollation_nameuser_accessuser_access_descis_read_onlyis_auto_close_onis_auto_shrink_onstatestate_descis_in_standby
master13SIMPLENOTHINGNULL08.04.2003 09:13100Latin1_General_CI_AS0MULTI_USER0000ONLINE0
tempdb23SIMPLENOTHINGNULL19.03.2014 14:36100Latin1_General_CI_AS0MULTI_USER0000ONLINE0
model33SIMPLENOTHINGNULL08.04.2003 09:13100Latin1_General_CI_AS0MULTI_USER0000ONLINE0
msdb43SIMPLENOTHINGNULL02.04.2010 17:35100Latin1_General_CI_AS0MULTI_USER0000ONLINE0
RSA53SIMPLENOTHINGNULL30.11.2012 15:59100Latin1_General_CI_AS0MULTI_USER0110ONLINE0
VIM_VCDB63SIMPLENOTHINGNULL30.11.2012 16:24100Latin1_General_CI_AS0MULTI_USER0100ONLINE0
VIM_UMDB7

3

SIMPLENOTHINGNULL28.01.2013 16:16100Latin1_General_CI_AS0MULTI_USER0000ONLINE

0

Reply
0 Kudos