1/28/2024 0 Comments Resync Edit for windows instal![]() If your OS is Windows Server 2012, use \\.\pipe\MICROSOFT#WID\tsql\query. Once SQL Management Studio Express is installed, launch it and it will prompt you to enter the server name to connect to. Include the SP level when searching theįor SQL Management Studio Express as sometimes it does matter. This will tell you what Service Pack level it is running. How to determine the version, edition and update level of SQL Server and its components If you’re not sure which version of SQL Server Management Studio Express to install, here’s an easy way to figure that out:įor Windows Server 2012 and Windows Server 2012 R2, go to C:\Windows\WID\Log and find the error log that has the version number you’re using. ![]() ![]() If you installed SUSDB on Windows Internal Database (WID), you will need SQL Management Studio Express installed in order to remove the database. If you installed SUSDB on Windows Internal Database Note that if you see #SSEE, this blog post is not applicable to you. If you see something that has the string #SSEE or #WID in it, you installed on Windows Internal Database, as demonstrated below: If you see just a server name or server\instance, you are using SQL server. Take a screenshot/registry export of this and look for the HKLM\Software\Microsoft\Update Services\Server\Setup If you are not sure which you used, you can check a registry key on the WSUS server located at This was specified when you installed SUSDB. How you connect via SQL Server Management Studio is different depending on whether you installed SUSDB on Windows Internal Database (WID) or SQL Server. Open SQL Server Management Studio and connect to the instance for SUSDB. ![]() Stop the WSUS service and IIS Service with the following command:ģ. Whatever the reason, here are the steps for recreating the SUSDB and the WSUS Content folder for a Windows Server 2012 based WSUS computer:Ģ. Typically speaking, I see people wanting to recreate the just the content dir if they accidentally unchecked the “download update files to this server only when updates are approved” and ended up with a hard drive full of unneeded files. In those cases you can find that a rebuild may be faster and easier than fixing the problematic SUSDB. There can be any number of reasons for this, but typically I see people doing this if their SUSDB is rather old, has a ton of unneeded updates in it, and maintenance has not been done on the SUSDB in years. Occasionally you may find that you want to start over in WSUS with a fresh database (SUSDB). First published on TECHNET on Oct 18, 2016 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |