Create Site Collection in New Database Using STSADM.EXE

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 -ownerlogin domain\username -sitetemplate SPSPORTAL#0 -title “MyTitle” -databaseserver vAPP05 -databasename abc_content_db


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

I hope this helps

Leave a Reply

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

You are commenting using your 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