• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 623
  • 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
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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