Saturday, November 19, 2011

Add a new content database to a Web application with PowerShell in SharePoint 2010


1.Verify that you meet the following minimum requirements: If you are using Windows authentication to connect to SQL Server, the user account must also be a member the SQL Server dbcreator fixed server role on the SQL Server instance where the database will be created. If you are using SQL authentication to connect to SQL Server, the SQL authentication account that you specify when you create the content database must have dbcreator permission on the SQL Server instance where the database will be created.
2.On the Start menu, click Administrative Tools.
3.Click SharePoint 2010 Management Shell.
4.At the Windows PowerShell command prompt, type the following command:

New-SPContentDatabase -Name <ContentDbName> -WebApplication <WebApplicationName>
Where is the name of the content database to create and is the name of the Web application to which the new database is attached.

No comments: