전체 글 (4) 썸네일형 리스트형 [MSSQL] Shrink transaction log USE TestDB; GOALTER DATABASE TestDBSET RECOVERY SIMPLE; GO DBCC SHRINKFILE (TestDB_log, 1); GOALTER DATABASE TestDBSET RECOVERY FULL;GO [Windows] CMD로 방화벽 정책 등록 netsh advfirewall firewall add rule name="정책명" dir=in action=block remoteip=IP,IP-IP in, all connection block [Windows] RDP Port 변경 HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp\PortNumber 수정 후 Rebooting [MSSQL] Table 별 용량 확인 Query select top 20 table_name = convert(varchar(30), min(o.name)), table_size = convert(int, ltrim(str(sum(reserved) * 8.192 / 1024., 15, 0))), UNIT = 'MB'from sysindexes i inner join sysobjects o on (o.id = i.id)where i.indid in (0, 1, 255) and o.xtype = 'U'group by i.idorder by 2 desc 이전 1 다음