PowerShell

Move SharePoint site collection to another Content Database

If you have some site collections but your database grows every day. In  MSSQL size of database should be less than 200 Gb. So if your content database size less than 100Gb you can easily use only 1 database – it’s easier to backup and restore it. Read more»

SharePoint

Create a new SharePoint content database from PowerShell

If you still don’t have a content database to move site collection, you need to create it. You can do it via SharePoint Central Administration or via PowerShell. Your account must be at least dbcreator role (better db_owner). Read more»

SharePoint

Get information about SharePoint content databases

Before moving sites between content databases, you should know a quantity of your databases for your WebApplication. You can move sites between content databases only if they are in the same WebApplication! Read more»

SharePoint

Remove Orphans objects in SharePoint using PowerShell

Using SharePoint there can appear orphans objects. This is when there must be an object – there are records about it in database, but there’s no this object. It can be a result of incorrect deletion or troubles with network while working. Read more»

SharePoint

Create SharePoint permission set – user can only add list items but don’t see them

The task – create SharePoint list so that users could only add list items but couldn’t see any items, even created by them, and, of course, couldn’t edit or delete them. May be there are some ways to do it, but I found this solution to create new permission set – user can add view […] Read more»

SharePoint

PowerShell script to extract file from zip-archive

The PowerShell script below extracts one file from zip-archive which contains several files. I use code like this to get files with financial references from zip-archives and update SharePoint lists from them. So there’s a lot of things where this sctipt can be used. Read more»

Windows

Find and remove duplicated records in SharePoint list

Today I was surprised to see duplicated records in SharePoint list which I imported and updated from XML-files. So I started to find a solution to find duplicated records, see them and delete. Read more»

SharePoint

How to open SharePoint site on Web front end (WFE) server

While creating a test SharePoint 2010 Farm I have installed all the software, solution, attached content database and wanted to see the result being on one of front-end servers, sp10wfe1. Test portal URL is http://sp10. So I entered URL in browser http://sp10 and wanted to see a site. Browser asked me about login and password, I entered them […] Read more»

SharePoint

Truncate SharePoint List using PowerShell. Method 2, faster

Unfortunately, there’s no equivalent for “Truncate” in SharePoint Lists. It’s not very good. If your list has more than 1000 items and you need to load only new data to list, you need to remove all existing items and to add new ones. This task is easy to code but not very fast to execute. Read more»

SharePoint

Popular Posts