Zephyr's SharePoint Blog

My Sharepoint world experience notes on day to day basis…..

Posts Tagged ‘specifying contend database’

Host Named Sitecollection or vanity URL

Posted by fillzephyr on September 10, 2008

 

Hey friends,

My client had a requirement of changing the regular URL name which is formed when you create a site collection http://vpc01:4444/sites/bluemoon123 to some good looking url name http://bluemoon123.corp.de for intranet purpose. This can be achieved by using host headed site collection or by giving vanity URL name. One more thing, this site collection should have its own content database WSS_Content_Bluemoon123 with the limit of 60 GB.

For specifying the particular QUOTA for your site collection you have to create a site quota template:

GO TO

Central Administration > Application Management > Sharepoint Site Management > Quota templates

In Template Name

Select Create a new quota template

In New Template Name give related name to your site collection quota here i had given name as bluemoon123.

In Storage Limit Values

(Tick both check boxes)

Limit storage to a maximum value of: 60000 MB

Send warning E-mail when site storage reaches: 50000 MB.

ClickOK 

And here a site collection quota bluemoon123 of 60 GB is created. 

Now GO TO

Central Administration > Application Management > Sharepoint Web Application Management > Web Application General Settings

In Web Application select http:// vpc01:4444

In Default Quota Template select bluemoon123

Click OK.

IT CAN BE DONE IN TWO WAY:

First Method:

Creating Content Database for your site collection:

GO TO

Central Administration > Application Management > Sharepoint Web Application Management > Content Databases

In Manage Content Databases

Click Add a content database

In Web Application select http:// vpc01:4444

Database Name: WSS_Content_Bluemoon123

Click OK

This will create a content database WSS_Content_Bluemoon123 for web application http:// vpc01:4444. 

Creating a site collection using the following stsadm command.

C:\>”Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN”\stsadm -o createsite -url http://bluemoon123.corp.de  -ownerlogin VPC01\abcdef -owneremail abcdef@abcd.de -sitetemplate STS#0 -title BlueMoon –hhurl http://vpc01:4444 

(For particular site template see below)

When Operation completed successfully on command window you can verify it by navigating in your central administration site through these path

Central Administration > Application Management > Sharepoint Site Management > Site collection list

Select web application http://vpc01:4444 here you will find the site collection which is created using STSADM tool. 

Now go to

Central Administration > Application Management > Sharepoint Web Application Management > Content Databases

In Manage Content Databases select Bluemoon123 and in Database Capacity settings put these values 

Number of sites before a warning event is generated: 1

Maximum number of sites that can be created in this database: 2

Click Ok  

So now any new site collection created on this web application is not specifying this content database and this database is now only related to site http://bluemoon123.corp.de.

 

Second Method:  

Creating Site collection with Content database using stsadm command 

C:\>”Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN”\stsadm -o createsiteinnewdb -url http://bluemoon123.corp.de -ownerlogin VPC01\abcdef -owneremail abcdef@abcd.de -sitetemplate STS#0 -title Bluemoon -hostheaderwebapplicationurl http://vpc01:4444 -quota Bluemoon123 -databaseserver vpc01 –databasename WSS_Content_bluemoon123. 

This will create a site collection http://bluemoon123.corp.de on content database WSS_Content_bluemoon123 with quota of 60GB. 

Now u have to follow these step 

Central Administration > Application Management > Sharepoint Web Application Management > Content Databases

In Manage Content Databases select WSS_Content_bluemoon123 and in Database Capacity settings put these values 

Number of sites before a warning event is generated: 1

Maximum number of sites that can be created in this database: 2

Click Ok 

So now any new site collection created on this web application is not specifying this content database and this database is related to site collection http://bluemoon123.corp.de.

If you do not have any access to the network side then ask your network administration team to create DNS Entry for your site collection otherwise it will show you the DNS Error. They will assign an ip address for this site collection. OR else

If you are running on your dev enviornment go to

C:\WINDOWS\system32\drivers\etc hosts.

Open hosts and write ip address and host header and save it.

 

After they assign IP address you have to configure your site collection in IIS Manager.

GO TO

Websites>web application 4444> right click   go to properties Select website tab nearby ip address there is Advanced… button click on it. 

Click Add…

In TCP Port enter 80.

In Host Header value enter bluemoon123.corp.de

Click OK. Ok. Ok.

Type the URL in browser http://bluemoon123.corp.de. Team site site collection is created. Because we had use site template as sts#0.

 

If you want to use different templates you can use this following name: 

GLOBAL#0 = Global template

STS#0 = Team Site

STS#1 = Blank Site

STS#2 = Document Workspace

MPS#0 = Basic Meeting Workspace

MPS#1 = Blank Meeting Workspace

MPS#2 = Decision Meeting Workspace

MPS#3 = Social Meeting Workspace

MPS#4 = Multipage Meeting Workspace

CENTRALADMIN#0 = Central Admin Site

WIKI#0 = Wiki Site

BLOG#0 = Blog

BDR#0 = Document Center

OFFILE#0 = Records Center

OFFILE#1 = Records Center

OSRV#0 = Shared Services Administration Site

SPS#0 = SharePoint Portal Server Site

SPSPERS#0 = SharePoint Portal Server Personal Space

SPSMSITE#0 = Personalization Site

SPSTOC#0 = Contents area Template

SPSTOPIC#0 = Topic area template

SPSNEWS#0 = News Site

CMSPUBLISHING#0 = Publishing Site

BLANKINTERNET#0 = Publishing Site

BLANKINTERNET#1 = Press Releases Site

BLANKINTERNET#2 = Publishing Site with Workflow

SPSNHOME#0 = News Site

SPSSITES#0 = Site Directory

SPSCOMMU#0 = Community area template

SPSREPORTCENTER#0 = Report Center

SPSPORTAL#0 = Collaboration Portal

SRCHCEN#0 = Search Center with Tabs

PROFILES#0 = Profiles

BLANKINTERNETCONTAINER#0 = Publishing Portal

SPSMSITEHOST#0 = My Site Host

SRCHCENTERLITE#0 = Search Center

SRCHCENTERLITE#1 = Search Center

SPSBWEB#0 = SharePoint Portal Server BucketWeb Template

 

Posted in SharePoint Blogs | Tagged: , , , | 1 Comment »