In this article we can explore a new feature in Squadron for SharePoint 2010.
Squadron is a Free SharePoint Administration tool available at www.sharepointcto.com.
What is Backup & Restore Permissions Add-in?
This is a new add-in in SharePoint that allows backing up existing permissions in SharePoint securable object & restoring it elsewhere.
Following are the levels of backup possible:
· Web Application
· Site Collection
Squadron also provides URL based filtering for backing up permissions. This will enable speed, context & reduce size of backup data.
What is contained in Permissions?
Following are the content of Permission:
3. User/Group Name
4. Members in Group
5. Owner if Group
6. Role Assigned
How to perform Backup?
Please follow the steps to perform backup:
Step 1: Execute Squadron
Execute Squadron from Start Menu > SharePointCTO folder. In the appearing scree se the URL.
Step 2: Click Permissions
From the left pane, click the Permissions item.
Step 3: Click Backup
Click on the Backup button in the appearing screen. You will get the following wizard.
Step 4: Check the Items
Expand the Web Application root item & Check the items to be backed up. You can right click & choose Check All command to check the sub items.
You can also use the Filter By Url on the bottom to filter by url.
Click the Next button to continue.
Step 5: View Permissions
In the next page you will see the Iterated Permissions as shown below:
The first column shows the Title of the Site / List / Item. The Type is displayed in the second column. The Url column is the key-column which will be used to identify the item uniquely.
The PermissionType column displays whether the permission is Unique or Inherited. The remaining rows contains the SharePoint Group / Domain User along with the role assignment.
Role Assignment can be Full Control, Contribute, Read or Custom Level.
Click the Next button to Save the file.
Step 6: Choose File
In the next page, choose the file name for saving the backup.
Step 7: Final Page
On clicking Next button you will see the last page which displays summary of the export.
It displays the number of web items, list items, library items along with unique/inherit permission types.
Click the Finish button to close the wizard.
Now we have successfully performed the Backup operation.
The file generated is in excel format & you may edit it for further optimizations. Please ensure the format of columns are retained.
Note: Please note that Folders (SPFolder) inside list/library are not included in permission backup.
How to perform Restore?
In the restore wizard, we are using a previous backup file to restore in a UAT/Production system. Click the Restore button from the Permissions Add-in.
You need to select the backup file in the next page.
In the next page you will be displayed the file contents as shown below:
In the next page choose the URL of the site to perform the backup.
Please note that the URL column of backup file will be used to match the target items.
Please note that this feature is only available for SharePoint 2010.
On clicking Next you can see the matching URLs.
You can verify the Source Objects in file & the Destination Objects in the destination Site URL specified.
On clicking Next you will see the Confirm prompt.
Click the Yes button to continue..
The restore operation will be performed & you can see the result as shown below:
This concludes our Restore Operation.
Permissions & Permission Levels http://bit.ly/YoKoX8
In this article we have explore the new feature in Squadron 2010. I believe this feature will be useful in backing up existing permissions before applying new ones. The Backup & Restore can be applied combined in scenarios of UAT Backup & Production Restore OR vice-versa.