<div>
Where is the setting in WSUS 4.0 to change the database to the new location ?
</div>


Where is the setting in WSUS 4.0 to change the database to the new location ?

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Can anyone here please asssit me in how to migrate the builtin SQL Server database for WSUS into the otehr SQL Server 2012 box ?<br />
<br />
The current one is running as below:<br />
<br />
<b>Update Services<br />
Microsoft Corporation<br />
Version: 6.3.9600.18057</b><br />
<br />
Instance name: <b>\\.\pipe\Microsoft##WID\ts<wbr />ql\query</b><br />
<br />

<pre><code id="code-10-28943881-1">Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
	Feb 10 2012 19:39:15 
	Copyright (c) Microsoft Corporation
	Windows Internal Database (64-bit) on Windows NT 6.2 &lt;X64&gt; (Build 9200: ) (Hypervisor)</code></pre>
<br />
I assume I can just Detach and attach the big MDF &amp;&nbsp;LDF files from <b>C:\Windows\WID\Data</b> into the new <b>SQL Server 2012</b> box ?<br />
<br />
and then keep the existing SQL Server builtin DB for reporting purpose ?
</div>
</div>


Hi All,

Can anyone here please asssit me in how to migrate the builtin SQL Server database for WSUS into the otehr SQL Server 2012 box ?

The current one is running as below:

Update Services
Microsoft Corporation
Version: 6.3.9600.18057

Instance name: \\.\pipe\Microsoft##WID\tsql\query

(CODE)

I assume I can just Detach and attach the big MDF & LDF files from C:\Windows\WID\Data into the new SQL Server 2012 box ?

and then keep the existing SQL Server builtin DB for reporting purpose ?

Migrating WSUS database to another SQL Server box ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.