If you would like to know what template a site is using (very useful
when you must move that site to another server; the same template will
need to be on the destination server), you can check in the content
database where that site resides.
-Open the database in SQL Enterprise Manager, and return all rows from
the ‘Webs' table of the content database.
-Find the site using the ‘FullURL' column; the template being used is
in the ‘WebTemplate' column.
-You can match this number with the descriptions in the XML files
located in the C:\Program Files\Common Files\Microsoft Shared\web
server extensions\60\TEMPLATE\1033\XML folder.