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

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
LVL 13
Senior IT System EngineerSenior Systems EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Harish KumarCommented:
Detailed information here,

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

Regards,
Harish Kumar
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
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.
Harish KumarCommented:
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;

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Justin SmithSr. System EngineerCommented:
IT - to answer your question, ALL SharePoint databases can run in the full version.  None of them are specific to Express.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.