<div>
Harish, thanks for the reply. <br />
<br />
So in this case of WSS 3.0 which of the database on the list can be installed or migrated to SQL Server 2005 ?<br />
<br />
I'm in the process of migrating the DB server but somehow I got stuck of determining which database can only resides with the SQL express edition 2005 and which one is or can be run on separate SQL server.
</div>


Harish, thanks for the reply.

So in this case of WSS 3.0 which of the database on the list can be installed or migrated to SQL Server 2005 ?

I'm in the process of migrating the DB server but somehow I got stuck of determining which database can only resides with the SQL express edition 2005 and which one is or can be run on separate SQL server.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Can anyone please let me know how many database that needs to be created separately by WSS 3.0 ?<br />
<br />
I got confused myself here, because my understanding is that the following DB needs to be created as separate DB:<br />
<br />
1. CA site - which stores the Configuration Database for all of the Site Collections.<br />
2. Search DB indexer<br />
3. WSS_Content - which stores all o the Infopath XML and its attachments.<br />
4. what else... ?<br />
<br />
your help would be greatly appreciated here.<br />
<br />
Thanks
</div>
</div>


Hi All,

Can anyone please let me know how many database that needs to be created separately by WSS 3.0 ?

I got confused myself here, because my understanding is that the following DB needs to be created as separate DB:

1. CA site - which stores the Configuration Database for all of the Site Collections.
2. Search DB indexer
3. WSS_Content - which stores all o the Infopath XML and its attachments.
4. what else... ?

your help would be greatly appreciated here.

Thanks

Database that SharePoint 2007 (WSS 3.0) create in SQL Server ?

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.