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 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

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 )

Google photo

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