WSS 3.0 seach fail after migration from Windows Server 2003 with SQL 2000 to Windows Server 2008 with SQL Server 2008
Hello we have a WSS 3.0 on a Windows Server 2003 with a single site, and we are trying to migrate it to another server with Windows Server 2008. All database are on a Microsoft SQL Server 2000. We installed WSS 3.0 from scratch on the new server. We put the default databases on a server with Microsoft SQL Server 2008. Then we made a backup in the production server with the following command: stsadm -o backup -url https://portal -filename musa.bak After that we restored the backup in the new server with the following command: stsadm -o restore -url https://uymvd18 -filename c:\sharepoint\portal-2010-10-05-21-00-06.dat -overwrite (portal is the name of the old server and uymvd18 is the name of the new one) Everything worked ok, but the when we try to do a search in the new server it returns no results. The funny thing is that if I create a new site within a new collection the search works ok. Search Service is running with a domain administrator account that has SA permission on the SQL Server. The Search Service is configured to index every 5 minutes and in the Timer Job Status says that it ran Sucessfuly. The worst part of this is that no errors appears in the event viewer so I dont know what else to do. It think it may be related to that particular site that for some reason its not being crawled. Please some help! Thanks!
October 19th, 2010 8:03pm

Hi, your old database is pointing to the old search database and you need to restore that database as well using: Stsadm -o spsearch -action attachcontentdatabase -databasename <content database name> [-databaseserver <server\instance>] [-searchserver <search server name>] or re-create the index using: stsadm -o spsearch -action stop [-f] and then stsadm -o spsearch -action start -farmserviceaccount <domain\name> (service credentials) [-farmservicepassword] <password> http://technet.microsoft.com/en-us/library/cc288507(office.12).aspx Cheers,Daniel Bugday Web: SharePoint Forum Blog: SharePoint By Bugday Twitter: Follow me on Twitter Technet: Ask a question on technet(swedish)
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2010 8:40pm

Hi Daniel, thank you for your fast answer! I'll try it and let you know. Best Regards, Claudio Astapenco.
October 19th, 2010 9:54pm

Hello Daniel, i did what you said, but the search is still not returning any results.Thanks, Claudio Astapenco.
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 9:44pm

Hi, Please check this kb whether it’s helpful for you. http://support.microsoft.com/kb/927919 Hope this helps Thanks! StanffordEverything will be fine.
October 21st, 2010 11:20am

Thank you very much! I'll try with that and I let you know
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 5:49pm

It worked out!!! Thank you Stanfford!
October 25th, 2010 2:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics