How to backup or export WSUS 3.0 database?

25 01 2008

Go to http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en and download the Microsoft SQL Server Native Client & Microsoft SQL Server 2005 Command Line Query Utility packages. Install these two msi files on the WSUS server.

Start CMD command shell and start the sqlcmd with the following options.

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

Now you are connected to the Windows Internal Database based on SQL Server 2005 edition which is used by WSUS 3 and some other included Windows Components like Windows Share Point Services 3.0.

To backup the database copy or type the sql command below. Change DISK option to a local folder of the server.

1> BACKUP DATABASE [SUSDB] TO DISK = N’G:\WSUS\UpdateServicesDbFiles\SUSDB.BAK’ WITH NOFORMAT, INIT, NAME = N’WSUS Database Backup’, SKIP,NOREWIND, NOUNLOAD, STATS = 10

2> Go

clip_image002

Comments : 1 Comment »
Categories : WSUS