Home Microsoft Windows Server 2008 and Server 2008 R2
WSUS Backing up and Restoring the Database Print E-mail


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'






< Prev   Next >
 

vcplogo 

    

 

DISCLAIMER: All advice, tips, guides and other information on this website is provided as-is with no warranty or guarantee. While most information is correct to the best of my knowledge, I am not reponsible for any issues that may arise in using the information, and you do so at your own risk. As always before doing anything; check, double check, test and always make a backup.

 

Popular

Help VMadmin

All resources on this site are provided absolutley free. However it takes time and money to keep the site running. If any information has been helpful to you or your company, and you wish to make a donation to help keep VMadmin.co.uk running you can do so via paypal, and it would be much appreciated.

Click to donate to VMadmin.co.uk via paypal.