Solved

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

Posted on 2014-01-01
4
439 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
  • 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

Want to promote your upcoming event?

Attending an event? Speaking at a conference? Or exhibiting at a trade show? Easily inform your contacts by using a promotional banner in your email signature. This will ensure your organization’s most important contacts are in the know.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now