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