question

CCyvan-1336 avatar image
0 Votes"
CCyvan-1336 asked CCyvan-1336 commented

WSUS SQL Choose

Hi everyone
I really need your help, thank in advance。 :)

I want deploy WSUS in multi-site, but i dont know how type SQL should I choose, MID or SQL server,

I will deploy one WSUS in HQ to sync with Microsoft and as upstream server (HQ have more than 300 windows servers), and deploy 3-5 WSUS in Branch offices (one office one WSUS, Fewer than one hundred servers )

How should I choose the SQL？

My plan is upstream server use SQL server, branch use MID, is this ok？ or do you have any better suggestion？

Thanks again. :)

sql-server-generalwindows-serverwindows-server-update-services
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LimitlessTechnology-2700 avatar image
1 Vote"
LimitlessTechnology-2700 answered CCyvan-1336 commented

Hello CCyvan,

Unless you have a specific DB requirement and already have a SQL License there are little reasons to chose a SQL WSUS unless literally thousands of machines and dozens of sites (and in that case, usually SCCM is preferred). WID will be fine, it has a 254GB limitation and you will never hit that limit. The main reason to use SQL is for performance (especially as time goes on even running the cleanup util), better management tools, and having the database on a separate drive/datastore. If you have a SQL license, and you are comfortable with SQL queries and DB management, use that. If not, use WID.


--If the reply is helpful, please Upvote and Accept as answer--

· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CCyvan-1336 avatar image CCyvan-1336 ·

Hi LimitlessTechnology
thanks for you answer, i I still have some doubts,
i have sql license, but it is not necessary to use sql server.
if use MID， do i need maintain MID, for example, backup and rebuild index if there fragments.
or can i use ssms to connect MID and manage it?
Compared with sql server, is this management risky?
thank you very much. :)

0 Votes 0 ·