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:


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'






Share this blog post on social media:

Social Links

Disclaimer

All advice, installation/configuration how to guides, troubleshooting and other information on this website are provided as-is with no warranty or guarantee. Whilst the information provided is correct to the best of my knowledge, I am not reponsible for any issues that may arise using this information, and you do so at your own risk. As always before performing anything; check, double check, test and always ensure you have a backup.

Copyright ©2016 Andy Barnes - Please do not copy any content including images without prior consent!

Designed and Hosted by Andy Barnes