SQL command SQL server 2008 trunc logs

USE COMPANYDB GO ALTER DATABASE COMPANYDB SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE (COMPANYDB_LOG,1) ALTER DATABASE COMPANYDB SET RECOVERY FULL WITH NO_WAIT GO USE COMPANYDB_2011 GO ALTER DATABASE COMPANYDB_2011 SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE...

w32tm set for ntp servers

txt file (just rename it to .cmd) time_ntp w32tm /config /update /manualpeerlist:”0.pool.ntp.org,0x8 1.pool.ntp.org,0x8 2.pool.ntp.org,0x8 3.pool.ntp.org,0x8″ /syncfromflags:MANUAL   w32tm /config /update /manualpeerlist:”0.pool.ntp.org,0×8...