Posted inMSSQL
List all MsSQL DB path
Migrate前可以先了解Database位置 MsSQL 2000 select * from sysaltfiles MsSQL 2005以上 select * from sys.master_files
Posted inMSSQL
SQL 2008 還原Master
cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUN...
Hong Kong version Windows + MsSQL 2008 Error
Performance counter registry hive consistency [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\0404] 複製到 [HKEY_LOCAL_MACHINE\S...
Posted inActive Directory Windows
AD Migration
除了需要檢查dcdiag, 還要檢查SRV record nslookup server 192.168.0.x set type=srv _ldap._tcp.dc._msdcs.xx.xx
Windows 2012 R2 Multi vLan tag
Windows 2012 R2 已經內建vLan tagging達成20/80基本需求 按NIC小組 新增Teaming介面 選左邊小組名稱再按右邊新增介面 vLan ID 共開了2個vLan tag及1個default vLan
Posted inWindows
Windows XP bridge
Bridge其實應該好簡單, 但測試一直都失敗, 最後發現好像不相容, 兩張LAN CARD都forcecompatmode enabled就可以了 netsh bridge show adapter netsh bridge set adapter 1 forcecompatmode=enable
Posted inActive Directory Windows
AD 2003增加AD 2012 R2後的錯誤
1. The DNS server was unable to create a resource record for fdb0ca48-99c5-4047-aaff-b3396816f239._msdcs.xx.xx. in zone xx.xx. The Active Directory d...
Posted inActive Directory Windows
The server holding the PDC role is down
AD Forest由2000升級2003後兩台Controller發生以下錯誤 dcdiag /test:FSMOcheck Warning: DsGetDcName(TIME_SERVER) call failed, error 1355 A Time Server could not be lo...