How to shrink SharePoint Content database?

How to shrink SharePoint Content database?

Right-click on the same database name and click Task-> Shrink-> Files. Use the File type drop-down menu and choose Log. You can use the default setting of Release Unused Space or select Reorganize Pages before releasing unused space. You can specify the file size by supplying a value in the Shrink file to option.

How do I view the contents database in SharePoint 2010?

Go to your Central Admin in your SharePoint server. On Application Management page select Manage content database from the “Databases” section. Then select the web application of which web application content database name you want. Finally you will get the Content Database name for the specific web application.}

How do I change Databases in SharePoint 2010?

To do this, follow these steps:

1. Make sure that you use a user account that’s a member of the following:
2. Start the SQL Server Client Network Utility (cliconfg.exe).
3. On the General tab, verify that TCP/IP is enabled.
4. On the Alias tab, click Add.
5. In the Server alias box, enter the name of the new SQL Server alias.

Is there a way to shrink the SharePoint database?

Unless you have scheduled shrinking maintenance operation, or you have automatic shrink enabled on the database, the files won’t get smaller even if you remove content from SharePoint. Shrinking operation itself is usually a quick procedure.

How big is the content database in SharePoint?

We have a large content database with 200 GB space in SP 2013 and it consists of two large site collections with 100 GB space each. We plan to permanently delete one site collection of size 100GB in content database, with running gradual delete timer job manually.

How much free space is there in SharePoint?

The environment I was doing this in, was a intermediate SharePoint 2010 environment, not a live environment. Also, the Shrink operation in the script allows you to specify a percentage of free space it should reserve for unused space. I used 5%. This way, for a content database of 100GB, 5GB of free space is retained.

How does SQL shrink to reclaim disk space?

The shrinking happens in 2 stages. The first stage is done with NOTRUNCATE. This means that SQL will move all pages to the front of the file but it will not reclaim unused space. The size stays the same. The next step is a shrink operation with TRUNCATEONLY.