windows server 2012

How to backup WSUS database

The Software Update Point (SUP) role in System Center Configuration Manager is closely related and dependent on Windows Server Update Services (WSUS). WSUS database may be located in the Windows Internal Database (WID). In this article we are going to show you how to backup this database in Windows Server 2012 R2 environment.

To backup WSUS database you just need to complete 4 easy steps:

  1. Download and install SQL Server 2012 SP1 Feature Pack. It will give you an opportunity to use SQL command line
  2. Download and install ODBC driver for SQL Server 11
  3. Create and run Backup WSUSdb script
  4. Create a task in Windows Task Scheduler to run the SQL script

We are going to miss the first 2 steps, because they really easy. So let’s start from the 3 step.

At first we need to create BackupWSUSdb.sql file that contains two lines:


F:\wsus_db_backup\WSUS_DB.BAK is the path to the backup file that you want to create (you can change the path and file name, it’s really up to you).


Running SQL script

To run the script you should use sqlcmd.exe utility:

sqlcmd.exe -S np:\\.\pipe\MICROSOFT##WID\tsql\query -if:\WSUS_DB_Backup\backupWSUSdb.sql

Action to launch the script

It’s quite trivial, just do everything like on next screenshot:

READ ALSO  Deleting an old Permalink in WordPress

backup wsus properties

That’s all. The WSUS database backup is created.

You may also like:

Windows Server 2012 Mailbox Role Process Execution... If you are trying to install Exchange 2010 on Windows Server 2012 and are receiving the error "Mailbox Role Process Failed.... Process execution faile...
Changing expired password via RDS in Windows Serve... This article shows how the remote users can change their expired RDS password themselves through RDP-connection to the Remote Desktop Services (RDS) f...
How to Install VPN Server on Windows Server 2012 R... In this article we will take a look on how to install VPN server on Windows Server 2012 R2. VPN (virtual private network) technology is used to create...
Configure Data Deduplication on Windows Server 201... In this tutorial we will show you a fast and easy way to configure Data Deduplication via Powershell. At first we need to add role for deduplicatio...
How to Install and Configure DNS Server on Windows... This article is a step by step tutorial on how to install and configure a DNS Server on Windows Server 2012. MS Windows Server 2012 is a great and ...