Home / SQL Server

SQL Server

Shredded Storage in SharePoint 2013

What Is Shredded Storage: Shredded Storage is going to help us with BLOBS (Binary Large Objects). It’s reduces the network IO by shredding the document into smaller pieces and reassembling when someone requests it. It reduces the amount of data saved in content databases. It decreases the amount of network traffic between the web servers and the SQL servers. Allows ...

Read More »

Restore Project server databases and instances to another farm

As I said in my previous post, today we will see how can we move project instances to another farm which including all your project server databases. Before we delete PWA databases from sql server we need to accomplish some tasks in the order: Delete/remove all the pwa instances from project server provisioning center (PWA service app) Connect to sql ...

Read More »

Can you move a single large site collection into multiple content databases?

Although single content databases of upto 200GB is possible in Sharepoint 2010, administering and managing such a db would be a nightmare. What would you suggest for options in a case where there is one site collection and one corresponding content database. Can you have more than one content db for that one site collection? Can you expand the table ...

Read More »

Recover Sharepoint 2013 databases from suspect mode.

This Post courtesy to: Lydia BronzeOriginal Post from: Blogs.cloudshare.com I restarted my SharePoint server, opened Central Administration and encountered the following error:Server Error in ‘/’ ApplicationRuntime ErrorDescription: An application error occurred on the server.In order to troubleshoot this issue I had to check couple of thing: Make sure SQL Server services are up and running Make sure the IIS application pools ...

Read More »