Solved

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

Posted on 2014-01-01
4
442 Views
Last Modified: 2014-01-09
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
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 6

Assisted Solution

by:Harish Kumar
Harish Kumar earned 334 total points
ID: 39750848
Detailed information here,

http://technet.microsoft.com/en-us/library/cc974471%28v=office.12%29.aspx

Regards,
Harish Kumar
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39750953
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.
0
 
LVL 6

Accepted Solution

by:
Harish Kumar earned 334 total points
ID: 39752949
WSS 3.0 installed with the Basic Installation or with the Advanced Installation followed by the Single Server option.The SQL Server 2005 version installed is officially called the "Windows Internal Database". It is an embedded version of SQL Server 2005 Express.

More info here,

http://social.technet.microsoft.com/Forums/sharepoint/en-US/59a2b088-3147-421e-adb4-c2bf2d725d71/windows-sharepoint-services-wss-30-sql-server-express-question?forum=sharepointadminlegacy

Regards,
Harish Kumar;
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 166 total points
ID: 39753755
IT - to answer your question, ALL SharePoint databases can run in the full version.  None of them are specific to Express.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question