29 March, 2013

The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space

Topology details:
-SharePoint Server 2010 with latest CU
-SQL Server 2008R2
-4 applications and 7 WFE’s

Problem Details:  Requirement comes up to replicate the production site collection to staging environment. We have taken the backup of the site by using PowerShell command without any issues.As soon as we started the restore command then it throws the following exception.

Error Message:
The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space.

Note:  One thing we need to understand that this is a very generic error message and does not have any correlation with the disk space available or not. If you have disk space available on the SQL Server as well as on the servers where SP is running then also you will face this error message. I think this is a BUG but not getting any documentation based on this to conclude the same. 

Troubleshooting done:
-Check the disk space on the SQL Server where LDF and MDF files are stored.
-Check the partition on the SQL SERVER in reference to data files
-Make sure the content database has enough space allocated.
-Make sure the databases does not have restrictive growth
-Make sure to check the disk space on the SP server where restore is running.  Approximately it should 2 times the DB size.

Resolution Applied:
-Go to “SQL Server Properties--Connections” and uncheck ‘Use query governor to prevent long-running queries’. Also, set “Remote query timeout” to 0.
-Stop and restart the "Windows SharePoint service Timer" 
-Restart IIS

If you have any queries/questions regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues, thank you.

28 March, 2013

Site Collection Codes


Parameter value
Description
GLOBAL#0
Global template
STS#0
Team Site
STS#1
Blank Site
STS#2
Document Workspace
MPS#0
Basic Meeting Workspace
MPS#1
Blank Meeting Workspace
MPS#2
Decision Meeting Workspace
MPS#3
Social Meeting Workspace
MPS#4
Multipage Meeting Workspace
CENTRALADMIN#0
Central Admin Site
WIKI#0
Wiki Site
BLOG#0
Blog
SGS#0
Group Work Site
TENANTADMIN#0
Tenant Admin Site
ACCSRV#0
Access Services Site
ACCSRV#1
Assets Web Database
ACCSRV#3
Charitable Contributions Web Database
ACCSRV#4
Contacts Web Database
ACCSRV#6
Issues Web Database
ACCSRV#5
Projects Web Database
BDR#0
Document Center
OFFILE#0
(obsolete) Records Center
OFFILE#1
Records Center
OSRV#0
Shared Services Administration Site
PPSMASite#0
PerformancePoint
BICenterSite#0
Business Intelligence Center
PWA#0
Project Web App Site
PWS#0
Microsoft Project Site
SPS#0
SharePoint Portal Server Site
SPSPERS#0
SharePoint Portal Server Personal Space
SPSMSITE#0
Personalization Site
SPSTOC#0
Contents area Template
SPSTOPIC#0
Topic area template
SPSNEWS#0
News Site
CMSPUBLISHING#0
Publishing Site
BLANKINTERNET#0
Publishing Site
BLANKINTERNET#1
Press Releases Site
BLANKINTERNET#2
Publishing Site with Workflow
SPSNHOME#0
News Site
SPSSITES#0
Site Directory
SPSCOMMU#0
Community area template
SPSREPORTCENTER#0
Report Center
SPSPORTAL#0
Collaboration Portal
SRCHCEN#0
Enterprise Search Center
PROFILES#0
Profiles
BLANKINTERNETCONT
Publishing Portal
SPSMSITEHOST#0
My Site Host
ENTERWIKI#0
Enterprise Wiki
SRCHCENTERLITE#0
Basic Search Center
SRCHCENTERLITE#1
Basic Search Center
SRCHCENTERFAST#0
FAST Search Center
visprus#0
Visio Process Repository