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