Thursday, 29 January 2009

How-to-create-a-Site-Collection-in-new-Content-Database

I been poking around to understand how to create new sites collection in new content databases and i found some brilliant articles on that.

So all you need to do is

Go to Central Administration > Application Management > Content Databases and set the existed content database to “Offline” mode

Add new content database in Central Administration > Application Management > Content Databases. (you can use different SQL server). Now all new sites will be created in this content database
Use the following command to export your site to the disk

“stsadm -o export -url http:// -filename c:\.exp -overwrite -nofilecompression -includeusersecurity -cabsize 1024”.

Delete your exported site collection in Central Administration > Application Management > Delete Site Collection

Create new empty site with the same path, via stsadm –o createweb/createsite;
Import you site to the same url, and site will be created in the new content database.
Use the following command for this

“stsadm -o import –url http:// -filename c:\.exp -nofilecompression -haltonfatalerror –includeusersecurity”

Now you will have you sub-site in new content database. It’s not very user friendly approach, and is an error proned a bit.

But there is one small tool - SharePoint Administration Tookit, which helps you to to reorganise the whole site collections. This feature will install a new section inside “Applications”and you can move your site collection via Central Administration interface.

And there is a nice article on this

http://msmvps.com/blogs/laflour/archive/2008/10/14/tips-to-create-a-site-collection-in-new-content-database.aspx

Monday, 19 January 2009

Simple-Steps-to-Create-Search-on-SharePoint-MOSS-2007-Sites

In this article I would take you through a 5 step process to create a new Search Site and then link that to your existing Team sites.

Step 1 : Create a New Site collection for Search Site, go to Central Administration > Application Management > Create Site Collection , select the template “Enterprise” and then “Search center with Tabs”.

Step 2 : Create an SSP (Shared Service Provider) http://technet.microsoft.com/en-us/library/cc262914.aspx once its created it will automatically gather all the default sites and will grab new sites created. If you want to create a new SSP you can go to the Central Admin > Application Management > Manage this Farm's Shared Services > Create SSP

Step 3 : Create a Content Source, SharePoint would already have created a default Content Source “Local Office SharePoint Server sites” which will be set by default pointing to all the created sites and the newly created sites but if you want to create specific Content Source you can do that in the Central Admin > Shared Services Admin > Click on the SSP, in the SSP site > Search Settings > Content Sources >New Content Source

Step 4 : Create a Scope which would be set by default , but if you need specific scope you might need to add it in the SSP site > Search Settings > View Scopes >New Scope .

Step 5 : So Once you create a Search Center Site all you need to is a bit Crawling and that’s it your SharePoint Search Site is ready. Go to the SSP Site > Search Setting > Content sources and crawl schedules > Hover over the SSP (Default - Content sources and crawl schedules) > Click on the Drop Down > Start Full Crawling.

And that’s it wait for some time (5 min) for sharepoint to Cache go to your Search Site its ready for Search.

Now the big question how will you link the search site to the Teams sites or other sites?

Go to the specific Site (Teamsites) where you want to set the search click on Site Action > Site Setting > Search Setting add the specific Search site’s result page you have created ( http://xsearch.lsc.local/Pages/results.aspx ) , point to the results page to get the search output.
That’s it Your site is ready for Search.

Friday, 16 January 2009

How can you list the appPools in a webserver when the IIS console is not available for some reasons or from the command prompt.

How can you list the appPools in a webserver from the command prompt ?
There is a script available in the c:\windows\System32 folder iisapp.vbs
Type in iisapp in the command prompt and that will work !!!
For the first time , this will throw an error saying "The script does not work with wscript" say OK and it will pop up again asking "Would you like to register CScript as your default host for VBScript?" say YES for that it will message saying "Succesfully registered CScript" say OK and type in the command once again in the command prompt and thats it , it will show all the "ACTIVE" appPools which are running fine, issuing this command it would list out all the appPools which are curretnly active and rendering Sites. BUT it might not show appPools which are stopped or idle. You can even list out the AppPools with Pid and even recycle, check out the options by iisapp/?

Wednesday, 14 January 2009

How-to-get-into-WebPart-Maintanence-Page-for-Sharepoint-site-MOSS

If you want to get into the Webparts maintanence page for any Sharepoint page all you need to do is append this query string to the end of the url and thats it you can get into the edit page.
Query String would be - ?contents=1 to the url in the browserEg - http://sharepointlogicssite/default.aspx?content=1
Often some webparts can cause problems on rendering, by logging to this mode you can always close the webparts causing the issue and try accessing the site.

Monday, 12 January 2009

Edit page command disabled

While editing pages on your SharePoint you probably encountered a situation when Edit page command in Site actions menu is disabled.
This is not an error. Edit page command will be disabled when another user has checked-out that particular page. To see which user has done so you will need to navigate to Pages library on your site.

If you have the right permissions and you need to edit the page, you can show the page editing toolbar and then click on Page -> Override Check Out.
This will undo any changes the other users has made and the page will be checked out to you, but is useful if you really need to make a modification to the page.