Print



If the Windows Internal Database is being used for the WSUS database, backups will have to be done slightly differently than full SQL Server installations that enable you to schedule backups.

Pre Reqs:
Microsoft SQL Server Native Client
Microsoft SQL Server Command Line Query Utility


Backup
1. Save the following to a SQL file named "WSUSDBBackup.sql", modifying the path for the backup destination as required.

BACKUP DATABASE [SUSDB] TO DISK = N'F:\WSUS\UpdateServicesDbFiles\SUSDB.BAK' WITH NOFORMAT, INIT, NAME = N'WSUS Database Backup', SKIP,NOREWIND, NOUNLOAD, STATS = 10
GO


2. Run the following, modifying the paths as required.

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -i'F:\WSUSDBBackup.sql' -o'F:\WSUS\DBBackup.log'

OR Schedule the following task.
sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -o"F:\WSUS\DBBackupLog.log" -Q "BACKUP DATABASE [SUSDB] TO DISK = N'F:\WSUS\SUSDB.BAK' WITH NOFORMAT, INIT, NAME = N'WSUS Database Backup', SKIP,NOREWIND, NOUNLOAD, STATS = 10"



Restore
1. Save the following to a SQL file named "WSUSDBRestore.sql", modifying the path for the backup destination as required.

RESTORE DATABASE [SUSDB] FROM DISK = N'F:\WSUS\UpdateServicesDbFiles\SUSDB.BAK'


2. Run the following, modifying the paths as required.

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -i'F:\WSUSDBRestore.sql' -o'F:\WSUS\DBRestore.log'