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

This entry was posted in MOSS 2007, SQLServerPedia. Bookmark the permalink.

6 Responses to How to create site directly in new content db

  1. lista de email says:

    really a great post and valuable information.

  2. Debora says:

    this site is very nice. regards.

  3. Nick says:

    Great trick again

  4. lista de emails says:

    good post.

  5. Pikavippivertailu says:

    I’m not that much of a online reader to be honest but your sites really nice, keep it up!
    I’ll go ahead and bookmark your website to come back later on. All the best

  6. Deepak says:

    i’m glad i could learn so much here in your blog. thanks a lot.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

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