How to restore a portal site from SQL database backups in SPS 2003

Right before the scheduled time for production upgrade from SPS 2003 to MOSS 2007, my customer’s SPS 2003 production environment was down. The database server was running on SQL Server 2000. The DBA told us ALL the SharePoint datababases just disappeared overnight and they didn’t have any script to track who deleted them or it’s…

1

How to migrate SPS 2003 My Sites to MOSS 2007 using the same web app hosting the Portal site

During my customer’s migration from SPS 2003 to MOSS 2007 testing environment, we encountered some challenges while migrating My Sites. With Bill’s help, I was able to fix the My Sites in testing environment. During the actual production upgrade, My Sites were sucessfully migrated. Here’s a recap of the fix I did in the MOSS testing environment: 1.      …

16

SQL Server 2005 Maintenance Plans and MOSS 2007 Databases

Earlier I saw one crawling error in my customer’s new MOSS environment after upgraded from SPS 2003. It’s not necessary related to the upgrade though.   I saw the following error in the crawl log:  sps3://domain.company.comException from HRESULT: 0x80040E2F (Exception from HRESULT: 0x80040E2F) From the event viewer on the index server: The start address <sps3://domain.company.com>…

2

Common security related errors in MOSS 2007

Access denied error when clicking Edit Schedule in Content Sources and Crawl Schedules within Search Settings. It’s a known issue. Here’s the fix http://support.microsoft.com/default.aspx?scid=kb;en-us;926959&sd=rss&spid=11373 Event Error with ID 6482 on Search query server(s) Error description: Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (1a646aac-52e4-4742-8bea-fd2dc3d87249).   The error may be a result of Group Policy setting and…

1

Search Usage Report in MOSS SSP Admin prompts for credentials and .NET 2.0 Fatal Execution Engine Error is seen in the Event Log

My customer’s new MOSS production environment has been upgraded from SPS 2003 and went live this morning, yes! Some minor issues remain though. Here’s one SSP issue I just fixed temporarily.   I went to the SSP Admin site, clicked on Search Usage Report under Search section, then I was prompted for credentials. I tried…

5

People Picker in MOSS 2007 can’t find people in non-default domains

Customer is seeing the following behavior:   “We went to SSP and clicked on User Profiles and Properties under the “User Profiles and My Sites” section and then clicked on View Import Connections and then added domain1.company.com to the Import Connections list and I started a full import. It completed in about an hour and imported users…

1