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

Published by Aryan Nava

Founder of "BlockchainMind", CTO for two Blockchain startup during 2018, Cloud/DevOps Consultant and Blockchain Trainer

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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: