locked
What are databases whose names start with WSS_Content_ ? RRS feed

  • Question

  • MOSS 2007- medium farm - dedicated SQL 2005.

    I have some conent databases which must be created by sharepoint. Their names are like:

    WSS_Content_********-****-****-************

    I can't find any of them in the central admin databases.

    What are they?


    Sara
    • Edited by Mike Walsh FIN Tuesday, November 16, 2010 6:42 AM ********-****-****-************ removed from Title
    • Edited by Sara_111 Wednesday, November 17, 2010 2:26 PM
    Monday, November 15, 2010 9:45 PM

Answers

  • WSS_Content_{GUID} databases are all created when ever you create an application in SharePoint. If you deleted the application they will can still be left behind.

    If you created SSP you would have created an application to  host it and to host mysites. they will create WSS_Content_{GUID} databases for them. you can look in Central Admin->application management -> Content databases to see which application is using which databases. You can switch between web applications by selecting the yellow web application link at the top and selecting change web application. 

     


    HTH
    Nagesh S

    Days and years do not mean anything to me. Moments shared are frozen
    in their time frame. Distance or time never fades them for me. I cherish them
    like my life. I have never let them sleep alone. Sachi
    • Marked as answer by Mike Walsh FIN Tuesday, November 16, 2010 6:42 AM
    Monday, November 15, 2010 10:02 PM

All replies

  • WSS_Content_{GUID} databases are all created when ever you create an application in SharePoint. If you deleted the application they will can still be left behind.

    If you created SSP you would have created an application to  host it and to host mysites. they will create WSS_Content_{GUID} databases for them. you can look in Central Admin->application management -> Content databases to see which application is using which databases. You can switch between web applications by selecting the yellow web application link at the top and selecting change web application. 

     


    HTH
    Nagesh S

    Days and years do not mean anything to me. Moments shared are frozen
    in their time frame. Distance or time never fades them for me. I cherish them
    like my life. I have never let them sleep alone. Sachi
    • Marked as answer by Mike Walsh FIN Tuesday, November 16, 2010 6:42 AM
    Monday, November 15, 2010 10:02 PM
  • Hi,

    I agree with Nagesh. When SharePoint 2007 creates new Content Databases(application/site), by default it adds a GUID to the end of the database name.

    http://blogs.technet.com/b/seanearp/archive/2009/03/14/renaming-crazy-sharepoint-database-names.aspx

    HTH.

    Thanks,
    Skancharla

    Monday, November 15, 2010 11:02 PM
  • Does this mean I can delete those databases with no problem if I don't find any of those databases in the Central Administration > Application Management > Content Databases   under any web application?

     

    Thanks,


    Sara
    Wednesday, November 17, 2010 2:22 PM
  • You may want to check if any other instences of SharePoint is sharing the sql server first. I would take that database offline first and wait to see if anything happens first.
    HTH
    Nagesh S

    Days and years do not mean anything to me. Moments shared are frozen
    in their time frame. Distance or time never fades them for me. I cherish them
    like my life. I have never let them sleep alone. Sachi
    Wednesday, November 17, 2010 11:49 PM
  • the database was in use. But, I can't find it anywhere from the Central Admin that the database is connected to anything.

    could it  be just crawl was holding it? I get the "no stat" error message in sql log for all two search databases while I have only one ssp.( I am on the third ssp generation and have deleted the previous versions)

    How can I get the list of databases in use from the stsadm?

     

     

     


    Sara
    Thursday, November 18, 2010 2:22 PM
  • Sara,

    The original question you asked in this thread has already been answered. The thread is in effect closed. Certainly many people will now ignore it.

    If you have new questions (as you have) please do not add them in this thread, but start a new thread for them with a new Title.

    (Moderator)


    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    Thursday, November 18, 2010 2:37 PM