Create Site Collection in New Database Using STSADM.EXE

November 25, 2010 — Leave a comment

In SharePoint 2007, if you want to create a new site collection in SQL Server

For example, I want to create a top level site in SharePoint but want a separate database like in the image

I open up STSADM.EXE and type the following commands

stsadm -o createsiteinnewdb -url http://vapp05/sites/abc -owneremail email@domain.com -ownerlogin domain\username -sitetemplate SPSPORTAL#0 -title “MyTitle” -databaseserver vAPP05 -databasename abc_content_db

Example

stsadm -o createsiteinnewdb -url http://intranet/sites/abc -owneremail admin@intranet.com -ownerlogin intranet\admin -sitetemplate SPSPORTAL#0 -title “ABC Site” -databaseserver devDB -databasename abc_content_db

I hope this helps

No Comments

Be the first to start the conversation!

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s