• Enfield, Waltham Abbey
  • 0844 567 4250

Search

Search Results For Passionate About IT Knowledge Base

How to move susdb.mdf for WSUS 3.0 in Windows SBS 2008

Feb 6

Written by:
Mon, 06 Feb 2012 10:24:15 GMT  RssIcon

How to move susdb.mdf for WSUS 3.0 SP1

WSUS on Windows SBS 2008 server can use a combination of Windows Internal Database and SQL Express. The susdb.mdf database can grow to be quite large and you may need to move it to a new location. follow the below steps to Stop the WSUS Service, Detach SUSDB from SQL Server then Move SUSDB.mdf and SUSDB_Log.ldf to the new location and finally Attach SUSDB to SQL Server again

Now onto the Solution...

1. Open a Command Prompt window, and run the following Commands to stop the WSUS service and IIS:
net stop wsusservice
iisreset /stop

2. If you don't already have Microsoft SQL Server Management Studio Express installed then go to this link and download it ot go to the next step:
http://www.microsoft.com/download/en/details.aspx?id=7593

 

3. Open the Microsoft SQL Server Management Studio Express while logged into the server as an Administrator and fill in the following information and then click connect:

  • Server type: Database Engine
  • Servername: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
  • Authentication: Windows Authentication
4. Once connected - expand the Databases node from the left pane and right click the SUSDB,
then select Tasks > Detach. The Detach Database window opens, select the 'Drop Connection' checkbox and click OK.

5. Open Windows Explorer and locate the SUSDB.mdf and SUSDB_Log.ldf - stored in C:\WSUS\SUSDB folder - Move it to a new location by using Copy and paste rather than move - just in case anything goes wrong while moving.

6. To reattach the database, right click on Database in SQL Server Management Studio Express and select Attach then on the Attach Databases page select the Add button and browse to the new location of the Database.


7. Finally start the WSUS and IIS services from a Command Prompt with the following commands:
net start wsusservice

iisreset /start

Note: Be sure to verify that the database is working by opening the WSUS Console.

If you have any problems following the above steps or the problem persists after successfully completing all the solutions please do not hesitate to Contact Us and one of our engineers will be happy to help.

Please Read:

If this Free tutorial was able to help - show us some support and help keep this knowledge base free by liking us on facebook, +1 us on Google Plus, install our amazing toolbar for instant access to our RSS feeds, follow us on twitter for all the latest trends in I.T and finally join our fantastic community forum where you can find help on all things I.T - from building your own PC to fix-it-yourself solutions from the Pros!


**Revenue from Pay-Per-Click Advertising is used to support this forum, any excess is donated to Doctors Without Borders**

Copyright © Passionate About IT 2012

6 comments so far...


Gravatar

My system has "SQL Server Management Studio" (for SQL 2008). When I try to open ..\MICROSOFT##SSEE, I get errors. "Cannot connect". "A network-related or instance-specific error occurred...".
I don't see any documentation out there about installing SQL Server Management Studio Express and SQL Server Management Studio on the same machine. Looks like I need to repartition my C:

By Paul on   Fri, 04 May 2012 00:40:33 GMT
Gravatar

Why do you need them both? SQL Studio should have all you need to administer your DB

By Aizen on   Sat, 05 May 2012 22:17:31 GMT
Gravatar

This really helped out. Didn't need to install sql studio as it was already preloaded ftw

By David Moore on   Thu, 23 Aug 2012 14:42:46 GMT
Gravatar

Thanks for the article. In case anyone else runs into this, when I tried to reattach the DB I got an error. Turns out I didn't have permissions on the new DB file. Gave myself full control and it attached no problem.

By Matt on   Sat, 03 Nov 2012 01:33:56 GMT
Gravatar

Great Article.. Thanks for posting it...

By Omair on   Fri, 26 Apr 2013 00:51:17 GMT
Gravatar

Excellent article, thank you!

By James on   Thu, 01 Aug 2013 16:13:16 GMT

Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 

Contact Us

Have an I.T Problem? Get in touch for an informal chat and find out how we can help

Click here

Blog Calendar

Archive
<March 2020>
MonTueWedThuFriSatSun
2425262728291
2345678
9101112131415
16171819202122
23242526272829
303112345
Monthly
Go
By continuing to use this site you agree to the use of cookies. To view our policy on cookies click here