New Storage and SQL Server capacity planning article for SharePoint Server 2013

The much anticipated, Storage and SQL Server capacity planning and configuration (SharePoint Server 2013) article is now live on TechNet. The product group invested many hours of testing both SQL Server 2008 R2 SP1 and SQL Server 2012 with SharePoint Server 2013. Use the resulting data in this article as a guideline to help you plan and deploy SQL Server in your…

1

SharePoint 2010 Databases and Windows PowerShell

There are several ways to maintain and configure, and backup and restore SharePoint 2010 databases.  The obvious way is with SharePoint Central Administration, however, the easiest and perhaps best way is to use Windows PowerShell cmdlets.  There are many cmdlets available to use with SharePoint databases. In an earlier blog I showed how to find…

0

Find active databases used by SharePoint Server 2010

One of the best ways to know what databases your SharePoint deployment uses is to keep a record and add database names each time you create a new database.This isn’t always easy as there usually isn’t enough extra time during the day to keep records. Plus, more often than not your SharePoint database maintenance tasks tend to occur…

1

Microsoft TechNet documentation for SharePoint Server 2010 Storage

Since Microsoft SharePoint Server 2010 is an application that relies on Microsoft SQL Server database software, we strive to provide IT pros comprehensive documentation about storage. The TechNet SharePoint Server 2010 Library contains the following articles: Storage and SQL Server capacity planning and configuration gives guidelines to help organizations plan and configure their storage needs on SQL…

0

Tip: Take a moment to rename databases during a database attach upgrade

SharePoint Products automatically generate GUID-based database names when databases are created, such as WSS_Content_ 2a24a7ecde1744d4823e31d77b266653. When you’re ready to upgrade, if you don’t have a handy farm inventory, it can take a little time and research to identify each database and map them to your Web applications and site collections. It sure would make farm…


SharePoint 2010 Products, SQL Server, Storage and Databases (oh my)

The SharePoint 2010 Products are, at core, Web applications built on SQL Server databases. To best administer an environment and keep it performing well, administrators should understand the following: How to choose the best version of SQL Server for their environment How to best configure and monitor SQL Server for SharePoint 2010 Products Which databases…