Steps to Backup Sharepoint List Attachments

we can export your list as Access Database with all attachments in one column of the table.

 

Now, go to the list action menu and click on ‘Open with Access’ option. Access 2007/2010 can export your list into database table including the attachment column.

Step-2:

Choose the first option to have offline backup

We have two options, w can export to a table which linked with SharePoint site and get synchronized back and forth all time or you can just export a copy of the list data which the option I wanted to do in this instance.

Step-3:

Access Table with Attachments Column

Once the exporting is done we can see the table where we find attachment column indicating how many attachments available with each row (list item).

Steps-4:

Double click on Attachments Cell to Open

And once we double click on one of the attachment cells we can view any of the attachments offline, and this is the easiest way to backup SharePoint list attachments for offline access

Configure the Secure Store Service SharePoint 2010

The Secure Store Service is a claims-aware authorization service that includes a secure database for storing credentials. These credentials usually consists of username and passwords but can also contain some other fields. Then these credentials can be used to connect external systems like SQL server, BCS etc.

The first time you access the Secure Stored Service it will ask you generate a new encryption key. This key will be used to encrypt and decrypt credentials stored in Secure store.

Generate new encryption key

Open Central Admin site. 

• Go to Application Management > Service Applications > Manage Service Applications.
• Select Secure Store Service and click Manage in Ribbon.
• On Ribbon click "Generate New Key". Enter Pass Phrase and click OK

Next step is to create Target Application. A Target Application Maps credential of a user, group to a set of encrypted credentials stored in secure store.

Create Target Application

• Click "New" in Ribbon under "Manage Target Application" Group.
• "Target Application ID": This is unique string to identify target application.
• "Display Name": Display name of target application.
• "Email": Email of primary contact of target Application.
• Target Application Type": Drop-down list, choose the target application type: There are two primary types for creating a target application:

Group, for mapping all the members of one or more groups to a single set of credentials on the external data source.

Individual, for mapping each user to a unique set of credentials on the external data source.
Click Next.
On this screen we can define fields that can be supply to external sources. By default two fields will be listed "Window User Name" and "Window Password".

Click Next.
Specify the Target Application Administrators and click OK.

Now if you have chosen Target Application Type as Individual the users can add individual credentials using default page

http://{your site url}/_layouts/SecureStoreSetCredentials.aspx?TargetAppId={TargetApplicationID}, where  {TargetApplicationID}  is the string typed in the "Target Application ID" box.