| =========================== OK:2019,2016 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| WID移動 |
|
| SUSDBのデータベースのディタッチ |
|
|
| net stop
w3svc |
|
| net stop
wsusservice |
|
|
| cd
C:\Program Files\Microsoft SQL Server\110\Tools\Binn |
|
| sqlcmd -S
\\.\pipe\Microsoft##WID\tsql\query |
|
| EXEC
sp_detach_db SUSDB |
|
| GO |
|
| exit |
|
|
| アクセス権のみコピー ★D:\WID\DataのサイズとDの空き容量は要確認。 |
|
|
| mkdir
D:\WID\bak |
|
| robocopy
D:\WID\Data D:\WID\bak SUSDB.mdf SUSDB_log.ldf /copyall |
|
| robocopy
C:\Windows\WID\Data D:\WID\Data SUSDB.mdf SUSDB_log.ldf /copyall /secfix /xo
/xn /xc |
|
|
| SUSDBのデータベースのアタッチ |
|
|
| sqlcmd -S
\\.\pipe\Microsoft##WID\tsql\query |
|
| EXEC
sp_attach_db @dbname = N'SUSDB', @filename1 = N'D:\WID\Data\SUSDB.mdf',
@filename2 = N'D:\WID\Data\SUSDB_log.ldf' |
|
| GO |
|
| exit |
|
|
| net start
w3svc |
|
| net start
wsusservice |
|
|
| デフォルトのファイル削除 |
|
|
| del /P
C:\Windows\WID\Data\SUSDB.mdf C:\Windows\WID\Data\SUSDB_log.ldf |
|
|
| =========================== |
|
| =========================== |
|
| WSUS
Windowws10機能更新配布個別設定 |
|
|
| C:\Program
Files\Update Services\Tools\WsusUtil.exe postinstall /servicing |
|
|
| IIS（WSUSの管理
- MIME） |
|
| .esd
application/octet-stream |
|
|
| =========================== |
|
|
| =========================== |
|
| SUSDBバックアップ |
|
|
| net stop
w3svc |
|
| net stop
wsusservice |
|
|
| cd
C:\Program Files\Microsoft SQL Server\110\Tools\Binn |
|
| sqlcmd -S
\\.\pipe\Microsoft##WID\tsql\query |
|
| BACKUP
DATABASE SUSDB TO DISK=N'D:\WID\SUSDB.bak' |
|
| GO |
|
| exit |
|
|
| net start
w3svc |
|
| net start
wsusservice |
|
|
| SUSDBリストア |
|
|
| net stop
w3svc |
|
| net stop
wsusservice |
|
|
| cd
C:\Program Files\Microsoft SQL Server\110\Tools\Binn |
|
| sqlcmd -S
\\.\pipe\Microsoft##WID\tsql\query |
|
| USE master
ALTER DATABASE SUSDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE
SUSDB FROM DISK=N'D:\WID\SUSDB.bak' WITH REPLACE ALTER DATABASE SUSDB SET
MULTI_USER |
| GO |
|
| exit |
|
|
| net start
w3svc |
|
| net start
wsusservice |
|
|
| =========================== |
|
| ===========================
OK:2019,2016 |
|
| WSUSコンテンツフォルダ設定 |
|
|
| cd
%programfiles%\Update Services\Tools |
|
| wsusutil
postinstall content_dir=D:\WSUS |
|
| =========================== |
|
| ===========================
OK:2019,2016 |
|
| SUSDBのデータベースファイル確認 |
|
|
| cd
C:\Program Files\Microsoft SQL Server\110\Tools\Binn |
|
| sqlcmd -S
\\.\pipe\Microsoft##WID\tsql\query |
|
|
| USE SUSDB; |
|
| GO |
|
| SELECT name,
physical_name FROM sys.database_files; |
|
| GO |
|
| exixt |
|
|
| =========================== |
|
| ===========================確認 |
|
| 自動更新確認しない |
|
| ［コンピューターの構成］＞
［管理用テンプレート］＞ ［Windows コンポーネント］＞ ［Windows Update］から「自動更新を構成する」を無効 |
|
|
| UAC無効（0が無効） |
|
| reg query
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System /v EnableLUA |
|
|
| IPv6無効 |
|
| ipconfig
/all |
|
| netsh
interface ipv6 isatap show state |
|
| netsh
interface ipv6 6to4 show state |
|
| netsh
interface teredo show state |
|
|
| プロダクトキー |
|
| slmgr /dli |
|
|
| =========================== |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|