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:
Tweet
Latest Blog Posts
- vSphere 7 U1 - Part 3 - Creating a Datacenter, HA/DRS Cluster and Adding a Host
- vSphere 7 U1 - Part 2 - Deploying vCenter 7.0 U1 VCSA
- vSphere 7 U1 - Part 1 - Installing ESXi 7.0 U1
- Veeam CBT Data is Invalid - Reset CBT Without Powering Off VM
- View Administrator Blank Error Dialog/Window After Upgrade