• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

How to identify which SQL Server DB is used by WSS 3.0 or SharePoint 2007 ?

Hi Folks,

Where can I identify which SQL Server is used by the WSS 3.0 or SharePoint Server 2007 ?

at the moment I'm about to delete the SQL Server 2005 Express Edition DB directory but not sure if it is being used by the current WSS 3.0 or not to store all of my Document Library items.
0
Senior IT System Engineer
Asked:
Senior IT System Engineer
  • 3
  • 2
2 Solutions
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks for the reply, but somehow I still cannot determine which is the correct SQL Server database that is in used by my WSS 3.0

There are multiple DB server in the SharePoint CA site and I'm not sure which one that is still in use.
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Senior IT System EngineerIT ProfessionalAuthor Commented:
So does in this case WSS 3.0 have SSP database as well ?
0
 
Harish KumarCommented:
In central admin -> servers in farm -> This will have the config db name and the server it resides on.

In the application management page you'll have the default DB server. Mostly all your content DB's are going to be there.

NO WSS 3.0 does not have SSP, unless you have project server or biztalk server installed.

Regards,
Harish Kumar
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks people !
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now