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 active databases in a SharePoint 2010 farm. In this blog I’ll show more things you can do to SharePoint databases using Windows PowerShell.
The following list is a mere sample of the SharePoint database tasks you can do by using Windows PowerShell:
This list merely shows a small sample of what you can accomplish using Windows PowerShell when working with SharePoint 2010 databases. For more details see the following topics:
For help building and using Windows PowerShell cmdlets, see Bill Baer’s Windows PowerShell Command Builder available here,
Thanks for reading,
Steve Hord, Technical Writer, SharePoint Content Publishing