라우터는 전화해서 arp cache 를 지워야 하는구나.....
카테고리 없음 / 2013. 11. 30. 14:59
netsh interface ip delete arpcache 로 되는게 아니구나....
Internet connection lost socket error 10055
카테고리 없음 / 2013. 11. 16. 17:23
http://support.microsoft.com/kb/196271/ko
http://esupport.trendmicro.com/solution/en-us/1036554.aspx
netsh winsock reset
To do this, perform the following:
|
1. |
Make sure that the latest patch for IWSS 2.5 is installed in your machine. |
|
2. |
Open the Registry Editor. |
|
Important: Always back up the whole registry before making any modifications. Incorrect changes to the registry can cause serious system problems. | |
|
3. |
Under the HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters hive, add the following "MaxUserPort" registry key with the following details: |
|
Data type: REG_DWORD Range: 5,000-65,534 (port number) Default value: 5000 | |
|
4. |
Set the value to "65530". |
|
5. |
Under the same hive, add the "TcpTimedWaitDelay" registry key with the following details: |
|
Data type: REG_DWORD Range: 0x0 0x12C (0-300 seconds) Default value: 0x78 (120 seconds = 2 min) | |
|
6. |
Set the value to "60". |
|
Note: These two keys do not exist by default. |
Transaction log 를 이용한 복구
카테고리 없음 / 2013. 11. 7. 17:07
select who.[Current LSN], sl.name, cast(who.[Begin Time] as datetime) [Begin Time], what.Operation
, what.[RowLog Contents 0]
, what.[RowLog Contents 1]
, what.*
from fn_dblog (NULL, NULL) who
join fn_dblog (NULL, NULL) what
on left (who.[Current LSN], 17) = left (what.[Current LSN], 17)
join sys.syslogins sl
on who.[Transaction SID] = sl.sid
where who.Operation = 'LOP_BEGIN_XACT'
and what.PartitionId = (select partition_id from sys.partitions where object_id = object_id('student'))
and what.[Context] IN ('LCX_HEAP','LCX_CLUSTERED')
and cast(who.[Begin Time] as datetime) between '20000101' and '20200101'
http://www.sqlservercentral.com/articles/Transaction+Logs/71415/
http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-1/
http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-2/