Here are som great scripts to manage SQL-server log See why you cannot shrink log files; select log_reuse_wait_desc,* from sys.databases as a1 –where name like ‘lois%’ order by a1.log_reuse_wait_desc See always on database status; Select last_commit_time, synchronization_state_desc,* from sys.dm_hadr_database_replica_states where database_id = 5 See how much data log files are using; DBCC SQLPERF(LOGSPACE); Shrink log …
I made some changes to a group policy but couldn’t see that the changes took effect. I couldn’t find any errors so i decided to make a new gpo – also because the old gpo had elements from the old internet explorer maintenance section. When I created the new gpo the changes i’ve made still …