Move SQL Server instance between servers - full text search question
-
quarta-feira, 1 de agosto de 2012 14:14
Hi all,
I've two servers both with SQL Server 2008 SP3, let's say serverA adn serverB. I've to move all databases and services that are now on serverA, at the end of my moving I plan to shutdown serverA.
Ok I'm aware on how to move databases, analysis services, reporting services. I've a question regarding full test search:
what I've to do to move services between the two servers? I've only installed full text search on serverB, I presume I've to copy something...
Todas as Respostas
-
quarta-feira, 1 de agosto de 2012 14:28
check for Full text Search on your database, check the image below
if not thee in the Server B, Generate script it on Server A copy it to Server B and execute it
Ramesh Babu Vavilla MCTS,MSBI
-
quarta-feira, 1 de agosto de 2012 15:00Thank you for the ansswer. I've checked one by one all my databases (they are 50). None of them have full text catalogs. So I don't have to copy anything, correct?
-
quarta-feira, 1 de agosto de 2012 20:47Moderador
Please see BOL under backup and restore full text catalogs:
http://msdn.microsoft.com/en-us/library/ms142511(v=sql.100).aspx
- Marcado como Resposta Maggie LuoMicrosoft Contingent Staff, Moderator segunda-feira, 13 de agosto de 2012 09:36
.png)
