Unable to find site template while restore, How to find Custom Template like e.g -11002 in SharePoint Database Server?

-
1) Find out the appropriate SharePoint Content Database from SharePoint Central Administration ->   Manage Content Database.
2) Login to SQL server which holds the SharePoint Content Databases
3) Right click on that SQL DB & select New Query
4) Run this query on that database & put appropriate error template & Title.

SELECT *--Title, WebTemplate,ProvisionConfig
FROM dbo.Webs
WHERE WebTemplate = 11002-- and Title = 'ABCD'
and FullUrl like '%ABCD%'

After executing this query you will come to know the faulty or Custom error site template , You can delete this if its in no use & try your restore again.

Comments

Post a Comment

Popular posts from this blog

How to Improve Workflow Performance in SharePoint Server 2010

-
Image
How to Improve Workflow Performance in SharePoint Server 2010 SharePoint workflows are getting  slow for several reasons. in my environment I'm having a problem with following performance issues, therefore in my environment i got following problems. When a item added to the library it takes some times to initiate the workflow. Workflow mail generating is not very fast sometimes. Workflows takes more time to process “Due to heavy load, the latest workflow operation has been queued. It will attempt to resume at a later time” is coming sometimes. I had a custom workflow approval web part and it is taking more than 30 seconds to proceed. Work Done I had a custom workflow approval web part and it is taking more than 30 seconds to proceed. here in my custom web part there is the function which is programmatically updating the workflow. SPWorkflowTask.AlterTask(item, data, false) the last parameter mentioning whether it is synchronous asynchronous. if  is it ...
Read more

PowerShell Script to Check and Generate Report on Access Rights for a Specific User:

-
Requirement: To ensure security, generate permissions report on all locations like (sites, lists, etc.) where a specific user has permissions. When people moving from one role to another, Its necessary to audit their permissions on sites and lists where user has access rights. But unfortunately, There is no out of the box ways to find all sites and lists where a particular user has been granted access in SharePoint with out using third party tools. Luckily, We've PowerShell! Lets find all SharePoint sites and lists where a particular user has access rights. PowerShell Script to Check and Generate Report on Access Rights for a Specific User: With this script, you can analyze and track the security effectively check what permissions on an account has been granted on each all places in SharePoint. This PowerShell script scans these areas to to retrieve a specific user's access rights: •Farm Administrator's Group •Central Administration Web Application Polici...
Read more

Disable Loopbackcheck using PowerShell

-
Disable Loopback Check Powershell To disable Loopback check run the following cmd on the (each) SharePoint server from a SharePoint PowerShell prompt (run as administrator): New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -value "1" -PropertyType dword
Read more