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

Ashi

Filed under: MOSS 2007