0

I help support SQL Server installation that hosts SharePoint and various related services. I never really looked at the database side of things until today when I noticed a whole bunch of databases with what look like GUIDs appended onto the database name. Can someone explain what these are? I tried to google for it but I didn't know what to google for and nothing came up from obvious google searches. Example of what I am asking about

2

1 Answer 1

3

Sharepoint System Databases. And they are pretty self explanatory, or? Search service, secure store, session state - easy to understand.

THe rest is a GUID that is used in case multiple instances are installed - the Guid makes the database name unique.

4
  • Thanks thats what I was looking for. I knew from the names what each database was but I was missing the part about the GUID. Makes sense now. Commented Dec 2, 2013 at 21:09
  • Basically you can install multiple different shaerpoint installs and use one sql server.... and every instance gets it's own database set.... identified by a GUID which is also in the sharepoint configuration. Old concept - and makes REALLY CRAPPY database names ;)
    – TomTom
    Commented Dec 2, 2013 at 21:15
  • How would you make the names globally unique, Tom? Commented Dec 2, 2013 at 22:20
  • No real alternatives there. Seriously. What I miss mostly is an easy way to replace the GUID with a custom name - often the sharepoint installs will have unique tracking codes from whoever sets them up and it would be nice to replace the GUID's with them. I KNOW it is doable in powershell....
    – TomTom
    Commented Dec 3, 2013 at 5:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.