두 SQL Server 간에 WSUS 데이터베이스를 마이그레이션하는 방법

두 SQL Server 간에 WSUS 데이터베이스를 마이그레이션하는 방법.

해결책 1. You have access to both SQL Servers

1. 달리다 Command Prompt as Admin on your server with WSUS Role;

2. Type and execute the next command:

net stop W3SVC && net stop wuauserv && net stop WsusService 

3. Run SQL Server Management Studio on the first (old) SQL 서버;

4. Navigate to your WSUS Database (by default SUSDB). Right Click and select Tasks\Detach;

5. Copy your WSUS Database 그리고 로그 files to a new location;

6. Run the new SQL Management Studio and Attach copied Database;

7. On your WSUS Server run 레지스트리 편집기 and change the key:

HKLM\SOFTWARE\Microsoft\UpdateServices\Server\Setup\SqlServerNameStart

8. Change server name from old SQL Server to new;

9. 달리다 Command Prompt as Admin on your server with WSUS Role;

10. 다음 명령을 입력하십시오:

net start W3SVC && net start wuauserv && net start WsusService

11. Test, by running WSUS Console.

해결책 2. You have files of WSUS Database

In case you can’t access to SQL Server instance with WSUS database with SQL Management Studio, but DB and Logs files are available.

1. 달리다 Command Prompt as Admin on your server with WSUS Role;

2. Type and execute the next command:

net stop W3SVC && net stop wuauserv && net stop WsusService 

5. Copy your WSUS Database 그리고 로그 files to new location;

6. Run SQL Management Studio on the new SQL Server and Attach copied Database;

7. Expand the보안, Right Click onLogins, 그런 다음 선택New Login;

8. 입력하다NT AUTHORITY\NETWORK SERVICE for the Login Name;

9. 클릭User Mapping and confirm that the user has thedbo Default Schema granted on theSUSDB 데이터 베이스;

10. 클릭좋아요 to create the login;

11. Right Click onLogins, 그런 다음 선택New Login;

12. 입력하다{WSUS Server Name}\WSUS Administrators for theLogin Name;

13. 클릭User Mapping and confirm that the WSUS Administrators Group is granted access to theSUSDB 데이터 베이스;

14. 클릭좋아요 to create the login;

15. On your WSUS Server run 레지스트리 편집기 and change key:

HKLM\SOFTWARE\Microsoft\UpdateServices\Server\Setup\SqlServerNameStart

16. Change server name from old SQL Server to new;

17. 달리다 Command Prompt as Admin on your server with WSUS Role;

18. 다음 명령을 입력하십시오:

net start W3SVC && net start wuauserv && net start WsusService

19. Test, by running WSUS Console.