MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Determine the GUID of a content Database

  Asked By: Jackie    Date: Dec 20    Category: MOSS    Views: 7496

In SharePoint 2007, I need to know the GUID of a content database for
running a stsadm command. How can I retrieve the GUID?



3 Answers Found

Answer #1    Answered By: Ebony Perkins     Answered On: Dec 20

I may be completely wrong, but AFAIK, STSADM sees the DB's by DB
name...not a GUID. The name might include a GUID, but it's just part
of the name.

Answer #2    Answered By: Anu K     Answered On: Dec 20

Some stsadm commands use them. I moved content  databases from one farm to
another without using a "preparetomove" command first. This caused some
"failure to sync" errors.
It's a long story but one of the commands to clean up the mess actually used the
GUID and database  name.
stsadm -o preparetomove -contentdb sqlserver:dbname -oldcontentdb <GUID>.

The stsadm -o sync -listolddatabes 5, command gave me the out of sync content
database GUIDs.

I crossed checked it with a sql query I found:

USE MOSS_SharePoint_Config '(Farm's configuration database)

WHERE Properties LIKE '%Microsoft.SharePoint.Administration.SPContentDatabase%'

At any rate, I'm still cleaning up the mess......

Answer #3    Answered By: Josie Barron     Answered On: Dec 20

I would guess that the GUID is used in that circumstance because the
"oldcontentdb" was orphaned or a new entry was made for the same name and
therefore could only be referenced by its GUID. This often happens when the GUID
of a Feature is changed and deployed while the old Feature is still installed.
The only way to uninstall it is to force remove it using its GUID.

Didn't find what you were looking for? Find more on Determine the GUID of a content Database Or get search suggestion and latest updates.