Moving the WSUS Database SUSDB.mdf

Moving the WSUS Database on SBS 2008/2011:
Open Windows SBS Console, Backup and Server Storage, Server Storage.
Click on Move Windows Update Repository Data.
Follow instruction and choose targer disk.

The process DO NOT move actual DB (SUSDB.mdf).
Open Microsoft SQL Server Management Studio Express as administrator to move the DB.
Connect to server: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Expand Databases and right click on SUSDB to choose Tasks - Detach.
Tick drop connection and ckick ok.

After DB detachet, move directory SUSDB to another location.

Back to Microsoft SQL Server Management Studio Express and right click on Databases - Attach.
Choose SBSDB.mdf from new location and ckick OK.

 


AUST IT - Computer help out of hours, when you need it most.

Find out why we do it for less.

About

AUST IT will help you resolve any technical support issues you are facing onsite or remotely via remote desktop 24/7. More...

Contacts

Reservoir, Melbourne,
3073, VIC, Australia

Phone: 0422 348 882

This email address is being protected from spambots. You need JavaScript enabled to view it.

Sydney: 0481 837 077

Connect

Join us in social networks to be in touch.

Newsletter

Complete the form below, and we'll send you our emails with all the latest AUST IT news.