SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

How to create site directly in new content db

Hey Friends,

Sometime when we build a new SharePoint site or site collection. We may feel to create in a new content db or database of our choice.
After all we are humans and sometimes not satisfied with GUI Default. So here are 2 ways to create site in db of our choice.

Two ways:

a) Through stsadm command

stsadm -o createsiteinnewdb –url <url> -databaseuser <database user name> -databasepassword <database password> -databaseserver <database server name> -databasename <database name> -sitetemplate <site template>

b) User interface and database status :: Trick to attempt

SharePoint databases have two status:

  • Ready:
  • Offline:

Offline seems to be “Not available” but exact meaning is “when the database status is set to Ready, the database is available for hosting new Site Collections. When the database status is set to Offline, no new Site Collections can be created”. Offline DBs can still be used for the existing site collections.

So when you want to create site in particular db make other db offline create site through GUI and again make the db Ready.

But now inspite of GUI you can have site created in db of your choice.

Hope I was able to describe the content based on my knowledge and learning.

Feel free to Rate and provide feedback if you find post useful

Hope this help

Filed under: MOSS 2007


I am Ashish Banga, and I work as a Senior Software Engineer at an IT Company. I have around 4 years of experience in Microsoft Technology, focusing on SharePoint and also on Windows Server. I work as a SharePoint Administrator. I am a B.Tech Graduate and Microsoft Certified Technology Specialist in SharePoint and also ITIL V3 Foundation Certified. I blog about what I face and what I learn, trying to share with all.


Leave a comment on the original post [ashishbanga.wordpress.com, opens in a new window]

Loading comments...