===========================

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

robocopy C:\Windows\WID\Data D:\WID\Data SUSDB.mdf SUSDB_log.ldf /copyall /secfix /xo /xn /xc

robocopy C:\Windows\WID\Data D:\2019アップ後 SUSDB.mdf SUSDB_log.ldf /copyall

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

===========================

===========================

WSUS Windowws10機能更新配布個別設定

C:\Program Files\Update Services\Tools\WsusUtil.exe postinstall /servicing

IIS（WSUSの管理 - MIME）

.esd application/octet-stream

===========================

===========================

SUSDBバックアップ　★事前にSUSDBのファイルがある「D:\WID\Data」のサイズは見ておかないと。

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

===========================

===========================

WSUSコンテンツフォルダ設定

cd %programfiles%\Update Services\Tools

wsusutil postinstall content_dir=D:\WSUS

===========================

===========================

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

===========================