kwizcom banner advertisement

Find and Delete Orphaned Site Collections, Items in SharePoint

8:30 PM    , , , , ,
Orphaned Site Collection in SharePoint Orphaned sites are broken sites created in situations like restore interrupt/failure. Often, sites without parent site reference, lists or libraries without site is referred as orphans in SharePoint. These objects are with broken relationship and should be deleted from SharePoint content databases prior to upgrade. During a migration project, I had to clean the SharePoint sites before migration as the preupgradecheck reported a huge list of orphaned sites. How to Delete Orphaned SharePoint Sites: There are many ways to remove orphaned site collections in SharePoint. To remove orphaned site collections in SharePoint 2007 / SharePoint 2010 or in SharePoint 2013, use one of the following method:  1.  Detach the content DB and attach again  2.  To detect orphaned items, use the following command line: stsadm -o databaserepair -url http://Web-App-URL -databasename <database Name > To delete orphaned items, use the following comma
Find and Delete Orphaned Site Collections, Items in SharePoint Find and Delete Orphaned Site Collections, Items in SharePoint Reviewed by Salaudeen Rajack on 8:30 PM Rating: 5

Host Named Site Collections in SharePoint

12:48 PM    , , , , , ,
What is Host Named Site collection? Host-named site collections are the best option if you want to create multiple root-level site collections within a web application. (Or Unique URL for each site collection). SharePoint supports both path-based & host-named site collections. The primary difference is: All path-based site collections in a Web application share the same host name (DNS name), where as each host-named site collection in a Web application is assigned with a unique DNS name. In other words: Host-named site collections allow you to create many root-level host-named sites within a single Web application.  With path-based sites, you are limited to a single root-level site collection within a Web application What are the advantage/disadvantages of Path Based vs Host Named Site Collections: Path-Named: The major advantage of path-based sites is that these sites can be accessed from any zone that you configure. Also, the alternate access mappings feature, which
Host Named Site Collections in SharePoint Host Named Site Collections in SharePoint Reviewed by Salaudeen Rajack on 12:48 PM Rating: 5

Build SharePoint 2010 Farm without Database GUIDs

5:08 PM    , , , ,
When setting up SharePoint, often its a annoyance from DBAs perspective, SharePoint adds GUIDs with Database names. Is there a way to build with out GUIDs? Yes, PowerShell is your Friend. Here is how: For Configuration Database: Once the installation is over, un-check the “Run Product & technologies configuration wizard” check box. Fire the powershell for SharePoint, and enter the below commands: New-SPConfigurationDatabase -DatabaseName SP2010_Farm_Config -DatabaseServer <Database Server Name> -AdministrationContentDatabaseName SP2010_Farm_AdminContent You can use the above PowerShell commands to build a Standalone SharePoint 2010 environment with Local user account! When prompted for user name password: Enter Domain\username. once completed, run the Products and technologies configuration wizard! Configure the Search Service application #Set the initial variables. $Search_Service_name = "Search Service Application" $Search_Service_account = &qu
Build SharePoint 2010 Farm without Database GUIDs Build SharePoint 2010 Farm without Database GUIDs Reviewed by Salaudeen Rajack on 5:08 PM Rating: 5

How to Hide User Names in Created by, Modified by Fields in SharePoint

3:28 PM    , , , ,
Requirement:   Had to provide complete anonymous entries in SharePoint task list by masking user names (as in SharePoint Surveys). Here is the Trick: There is a Property for SharePoint List, called "ShowUser". we can set that to "False" using PowerShell or C# object model. PowerShell script to Hide User Names in SharePoint: $SPweb=Get-SPWeb " http://sharepoint " $SPlist=$SPweb.Lists["Tasks"] $SPlist.ShowUser=$false $SPlist.Update() and here is the effect in action: For SharePoint 2007 Hide User Name: For MOSS 2007, You can do the same using C# code (PowerShell also possible!) namespace HideUserInfo { class HideUserInfo { static void Main(string[] args) { using (SPSite oSPSite = new SPSite("http://SharePoint.com")) //Site collection URL { using (SPWeb oSPWeb = oSPSite.OpenWeb("News")) //Subsite URL {
How to Hide User Names in Created by, Modified by Fields in SharePoint How to Hide User Names in Created by, Modified by Fields in SharePoint Reviewed by Salaudeen Rajack on 3:28 PM Rating: 5

SharePoint Datasheet view in Read-only mode ? Try these Solutions

2:07 PM    ,
Issue: In Datasheet sheet view, users unable to edit anything. Its in always Read-Only mode. Solution: Check the following to fix SharePoint list in datasheet view is read only: Content Approval must be turned OFF  Microsoft KB: http://support.microsoft.com/kb/2274841      2.  Some of the columns are dependent on the Microsoft Access, Check whether MS-Access is installed in client machine.      3.  Check whether you have permission to edit      4.  The document in the current row may be checked out by a user.      5. Attachments are read-only in a list that requires content approval. You cannot view or edit attachments in any of the views.      6.  Certain columns, such as Created By and Modified, are always read-only.      7.  There may be an unresolved conflict or error in the selected row or column. Resolve the conflict or error before attempting to edit the selected row or column. Update: To use edit in Datasheet view, even with content approval turned ON, us
SharePoint Datasheet view in Read-only mode ? Try these Solutions SharePoint Datasheet view in Read-only mode ? Try these Solutions Reviewed by Salaudeen Rajack on 2:07 PM Rating: 5

Opening/Saving Documents in SharePoint is Very Slow - Solution

6:40 PM    , , , , ,
Recently, an end user reported the issue: Opening/Saving Office 2007 Documents to MOSS 2007 is very Slow.  Here is his detailed complaint: "Often at work, I sometimes receive a message after 10 minutes or so that 'Excel Is not responding' in the upper corner of the screen. When this happens, the document is not saved and I must reopen it and make the same changes again. It does not always appear to be able to recover. When I am waiting on a document to save or load, I cannot move to another Excel document even if it was open at that time. Even when I do a 'save as' to save to my C drive, it takes forever. It is very frustrating not to be able to have documents available when needed. I cannot give quick responses when am asked for information. Can you please help?" Here is the simple fix for these kind of issues: Open up Internet Explorer Go to Tools > Internet Options  Click the Connections Tab > then click the LAN Settings button
Opening/Saving Documents in SharePoint is Very Slow - Solution Opening/Saving Documents in SharePoint is Very Slow - Solution Reviewed by Salaudeen Rajack on 6:40 PM Rating: 5
Powered by Blogger.