Hi there! Welcome to my blog. My name is Ivan. I am a Dutch IT Professional working as Principal IT Consultant. Go here and download sqlncli.msi + SQLServer2005_SQLCMD.msi package (Microsoft SQL Server Native Client & Microsoft SQL Server 2005 Command Line Query Utility). Install these two msi files on the WSUS server.
Start a CMD command shell and run 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 Express 2005 edition. This sql engine is used by the WSUS 3 sever and some other Windows Components like Windows Share Point Services 3.0.
To backup the database copy, type the sql command below. Change DISK option to a local folder on the server.
BACKUP DATABASE [SUSDB] TO DISK = N'G:\WSUS\UpdateServicesDbFiles\SUSDB.BAK' WITH NOFORMAT, INIT, NAME = N'WSUS Database Backup', SKIP,NOREWIND, NOUNLOAD, STATS = 10<br />Go
susika
yeah, that’s exactly what I’ve searched for. I changed it to a script with -i , so you can automate it. Thanks.