Shulou(Shulou.com)06/02 Report--

1. Open the I database console\\. Pipe\ mssql$microsoft##ssee\ sql\ query to connect to the database and select SUSDB database task backup

two。 Backup mode full backup type only copy backup select disk and file name and make sure the copy is backed up to the new server C root directory

3. Create a new query in the sql Management console to wait for completion

USE master

GO

ALTER DATABASE SUSDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

DROP DATABASE SUSDB

GO

4. New query

RESTORE DATABASE [SUSDB] FROM DISK = NumC:\ wsus.bak' WITH FILE = 1, MOVE NissSUSDB' TO nudged:\ WSUS\ UpdateServicesDbFiles\ susdb.mdf', MOVE Numeric SUSDBlog' TO nude:\ WSUS\ UpdateServicesDbFiles\ SUSDB_log.ldf', NOUNLOAD, STATS = 10

Encounter an error

Message 3605, level 16, status 1, line 1

Schema validation failed for database 'SUSDB'.

Message 3013, level 16, status 1, line 1

RESTORE DATABASE is terminating abnormally.

Solution:

5. Cd to directory to execute.\ wsusutil.exe postinstall SQL_INSTANCE_NAME= "CNTNJ-P-SCCM01\ MSSQLSERVER" CONTENT_DIR=D:\ WSUS

6. Execute powershell script

$updateServer = get-wsusserver

$config = $updateServer.GetConfiguration ()

$config.ServerId = [System.Guid]:: NewGuid ()

$config.Save ()

7. Cd to directory execution.\ WsusUtil.exe postinstall

8. Examination result

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.