Find and Delete Orphaned Site Collections, Items in SharePoint

July 31, 2011    , , , , ,
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
Read More
Find and Delete Orphaned Site Collections, Items in SharePoint Find and Delete Orphaned Site Collections, Items in SharePoint Reviewed by Salaudeen Rajack on July 31, 2011 Rating: 5

Host Named Site Collections in SharePoint

July 24, 2011    , , , , , ,
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
Read More
Host Named Site Collections in SharePoint Host Named Site Collections in SharePoint Reviewed by Unknown on July 24, 2011 Rating: 5

How to Delete a File from SharePoint Document Library using PowerShell?

July 21, 2011    , , , ,
Requirement: Delete a file from SharePoint document library using PowerShell PowerShell to delete file from document library: At times you may have to delete a particular file from a library. In one of my case, as part of a deployment, before copying certain files, I had to check whether the particular file exists already in a document library, if yes, I must delete that particular file. Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue #Variables for processing $WebURL = "http://intranet.crescent.com" $ListName = "Documents" $FileName="sharepoint databases v1.pptx" #Get Web, List and List Item of the File $Web = Get-SPWeb $WebURL $List = $Web.Lists[$ListName] $ListItem = $List.Items | Where {$_["Name"] -eq $FileName} If($ListItem -ne $NULL) { #Delete the file $ListItem.File.Delete() Write-Host "File has been Deleted!" -f Green } else { Write-Host "File Not Found!" -f Yellow }
Read More
How to Delete a File from SharePoint Document Library using PowerShell? How to Delete a File from SharePoint Document Library using PowerShell? Reviewed by Salaudeen Rajack on July 21, 2011 Rating: 5

Build SharePoint 2010 Farm without Database GUIDs

July 14, 2011    , , , ,
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
Read More
Build SharePoint 2010 Farm without Database GUIDs Build SharePoint 2010 Farm without Database GUIDs Reviewed by Unknown on July 14, 2011 Rating: 5

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

July 12, 2011    , , , ,
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 {
Read More
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 Unknown on July 12, 2011 Rating: 5

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

July 07, 2011    ,
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
Read More
SharePoint Datasheet view in Read-only mode ? Try these Solutions SharePoint Datasheet view in Read-only mode ? Try these Solutions Reviewed by Unknown on July 07, 2011 Rating: 5

Opening/Saving Documents in SharePoint is Very Slow - Solution

July 01, 2011    , , , , ,
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
Read More
Opening/Saving Documents in SharePoint is Very Slow - Solution Opening/Saving Documents in SharePoint is Very Slow - Solution Reviewed by Unknown on July 01, 2011 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.