SharePoint is my hammer and everything looks like a nail.

Fixing: Manage Content and Structure in SharePoint 2010 After my "C" network migration, the link for Manage content and Structure under site actions was failing. Looking through the logfiles I found the relevant error: Failed to determine the setup path of the list schema for feature {e32e1e6f-fb94-4090-...}, list template 100. I googled the GUID, and came up with nothing. This was not one of the standard site features. This was some golden nugget of excrement that a prior admin must've found and installed on a whim. Or something useful. Or a Fab 40 Template. Hard to say which with nothing to go by but a guid. I searched web configs with no success. To find out which list was the offending one I had to open all the lists. Never mind sites and document libraries, just lists as the error said "list". I went to site actions, view all site content and popped each list open in a new tab. All of them came up but one (fortunately). This list was ...

The file /_catalogs/masterpage/_controltemplates/Welcome.ascx does not exist. This was the error I found in the logfiles as the page gave the usual correlation ID of head scratchiness.  In my case it was popping up only when users were creating a new page, but there are several places you could hit this.  some might even case a whole site to come up as a 404 error. In IIS you will find _controltemplates, but no _catalog.  Resist the urge to create a _catalog, just like I didn't.  This won't fix the issue, but will move your error along. After some googling, I found this tidbit : Most likely the tilde sign "~" has dissapeared in your references on the masterpage after editing it in the sharepoint designer. In the beginning of the masterpage you have register statements that should look like this Code Snippet <%@ Register TagPrefix="wssuc" TagName="Welcome" src="~/_controltemplates/Welcome.ascx" %> <%@ Reg...

This one is not my script, but it's too useful not to share.  I ran into an issue while trying to move from a source of SQL 2008 to a destination of SQL 2008 R2 that my restore failed because the file paths were not the same.  So I used this script to generate the backup and restore commands. SET NOCOUNT ON DECLARE @Table TABLE (LogicalName varchar(128),[PhysicalName] varchar(128), [Type] varchar, [FileGroupName] varchar(128), [Size] varchar(128),             [MaxSize] varchar(128), [FileId]varchar(128), [CreateLSN]varchar(128), [DropLSN]varchar(128), [UniqueId]varchar(128), [ReadOnlyLSN]varchar(128), [ReadWriteLSN]varchar(128),             [BackupSizeInBytes]varchar(128), [SourceBlockSize]varchar(128), [FileGroupId]varchar(128), [LogGroupGUID]varchar(128), [DifferentialBaseLSN]varchar(128), [DifferentialBaseGUID]varchar(128), [IsReadOnly]varchar(128), [IsPresent]v...

Here's a finished version of my SQL script to backup and restore SharePoint 2010 databases. I discuss the idea in detail here: http://www.sharepoint.name/2014/04/make-sql-server-write-its-own-scripts.html But this is the more finished version This script is one simple query that generates a column containing each command. SELECT 'BACKUP DATABASE ['+ name +'] TO DISK = ''\\SERVER102\B$\SQL\FULL\'+ NAME +'.BAK '' WITH STATS=10' AS FullBackup, 'BACKUP DATABASE ['+ name +'] TO DISK = ''\\SERVER102\B$\SQL\DIFF\'+ NAME +'.BAK '' WITH DIFFERENTIAL, STATS=10' AS DiffBackup , 'RESTORE DATABASE ['+ name +'] FROM DISK = ''\\SERVER102\B$\SQL\FULL\'+ NAME +'.BAK '' WITH NORECOVERY, REPLACE' AS FullRestore , 'RESTORE DATABASE ['+ name +'] FROM DISK = ''\\SERVER102\B$\SQL\DIFF\'+ NAME +'.BAK '' WITH RECOVERY' AS DiffRestore from s...

Edit User Profile Data in SharePoint 2010 This a useful little quick fix.  The better way to fix your bad data is through the AD sync.  If you do change data through this method for expediency, be sure to check it in AD as well or you risk your changes being overwritten. Log in to Central Admin Click Application Management Click Manage Service Applications Click on the User Profile Service Application Click Manage User Profiles Search for the user Click the user and select Edit my Profile Make your changes Click Save That's all it takes to edit the profile.

Here's a 4 step method to migrate SharePoint 2010 data from 1 SQL Server to another. This was the method I used for the "S" Network, combined with other steps, but this process migrated the data. First, the commands.  Each step is actually a script that hits each database.  I chose to write out each command on a new line and just run it in the SQL query window. See http://www.sharepoint.name/2014/04/make-sql-server-write-its-own-scripts.html  for that script. BACKUP DATABASE [NAME] TO DISK = '\\PATH\FULL\NAME.BAK' RESTORE DATABASE [NAME] FROM DISK = '\\PATH\FULL\NAME.BAK' WITH NORECOVERY, REPLACE BACKUP DATABASE [NAME] TO DISK = '\\PATH\DIFF\NAME.BAK' WITH DIFFERENTIAL RESTORE DATABASE [NAME] FROM DISK = 'PATH\DIFF\NAME.BAK' WITH RECOVERY Here's the explanation Start with a full backup of Production. This can be done without downtime. Restore to the NEW SQL database server. During the ASI downtime window turn off access t...