backup-restore in SharePoint 2010

Hello All,

I know backup-restore is a very important entity in SharePoint 2010 and is being heavily used by Administrators/Developers/IT Pros. Its my responsibility to share my thoughts on such a important topic so thats why i am sharing this by means of knowledgebase forums.

please refer the following articles and let me know in case of any queries/questions, Thank you

SharePoint 2010: Backup/Restore with PowerShell Command 
http://sharepointknowledgebase.blogspot.in/2012/06/sharepoint-2010-backuprestore-with.html

Backup Restore in SharePoint 2010 
http://sharepointknowledgebase.blogspot.in/2012/06/backup-restore-in-sharepoint-2010.html

manage access request

Does "manage access request" functionality still available in SP2013?

Yes, you are right- still there!

Here are the details:
1. Open the site collection on which you are working. 
2. Site actions 
3. Site settings 
4. Under ‘users and permissions’ section 
5. Site permissions 
6. Please refer the Ribbon on the top 
7. Permission tools 
8. Manage access requests 
9. Select the checkbox ‘allow request for access’ and enter the appropriate email id as per your requirements and click OK

InfoPath Error: This session has exceeded the amount of allowable resources

Hello, 

I have published an infopath form on my SharePoint 2010 site collection and getting the following error message while opening: 
InfoPath Error: This session has exceeded the amount of allowable resources 

Resolution is very simple.

Here are the details:
Increase the form actions in configuring InfoPath services section as mentioned below:- 

Go to Central Administration of the SharePoint server. 

Click on Application Management 

In the section "InfoPath Forms Services"-->select Configure InfoPath Forms Services. 

In the Number of Actions per Post back, enter some max value around 250 or 300 depends on your project form requirement.

Last Access date / time for site collection

How to find out dead sites? 

How to find out unused sites? 

How to find out the sites which has not been updated from a long time? 

http://sharepointknowledgebase.blogspot.com/2014/02/last-access-date.html

access denied business data connectivity

Create an External Content type based on backend SQL Server Database and create an External list based on it.

Open the Site in SharePoint Designer 2010: http://portal.contoso.com

Provide username and password in the promotion for open the site

Opening the site http://portal.contoso.com by communicating with the Web service

Retrieving External Content type Report

Create new external content type: Define General Properties for External Content type

Content type name: Contact; Name Space: http://portal.contoso.com; Office Item Type: Contact; Enable offline Sync to External list 

External System: Click here to discover external data sources and define operations 

Add Connection 

Managing Connections to external data sources and the operations for this external content type

External Data Source Type Selection: SQL Server -> Open the SQL Server Connection

SQL Server Connection: Populate the Database Server and Database name in the box

 Navigate to the appropriate database (AdventureWorks) and scroll through the required table (Contact)  

Table: Verify the available operations for that table

Operations for External content type means action that can be performed on the data associated with the external system -> Click on Create all Operations

Specify the parameters for the Operation

Example: Get the “Last Name” parameter-> Office property: Last Name; Check the Show in Picker box.

Filter Parameter Configuration

Add Filter Parameter: Add a Limit filter to the Query Item List Operation

Add Filter Type: Limit (Strongly Recommended to add a filter of type ‘Limit’ for this operation type)  

Filter Filed: None; Default value given as “100” for the limit filter type

Save the Content type to the Business Data Connectivity Metadata Store

Create an External List for the External Content type

External List : Business Contacts ; System Instance : AdventureWorks

External List: Business Contacts Created

Set Business Connectivity Store Permissions

List and Libraries -> External List-> Business Contacts -> Open Preview in Browser

Access is being denied by Business Data Connectivity Service (Reason: There is no permission for viewing this list)

Set the permission: Open CA->App mgmt. ->Manage Service Applications-> Business Data Connectivity Service->Manage->Set Metadata Store Permissions 

 Add Contoso\Administrator and feed all the (Edit, Execute, Selectable in Clients, Set Permissions) permission to the user.

Propagate permissions to all BDC Models, External Systems and External Content types in the BDC Metadata Store.

Work with External Content type in the Browser: Navigate to the http://portal.contoso.com

List will display with the no permission error now

Edit Item: Edit any of the lists and include any data in the list.

Example: Data Included in one of the List

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.