TodoSQL Blog de SQL Server en español

Hola a todos !, les cuento algo que nos paso realizando un restore de base de datos con catalogo de full text sobre un SQL Server 2005.

Se realizó un restore de una base de datos con path distintos al origen. La sentencia fue la siguiente:

RESTORE DATABASE [MyBase] FROM DISK = 'D:\MSSQL.1\MSSQL\Backup\MyBase_BACKUP.bak' WITH FILE = 1, MOVE 'MyBase' TO 'd:\MSSQL.1\MSSQL\MyBase.mdf', MOVE 'MyBase_log' TO 'd:\MSSQL.1\MSSQL\MyBase_1.ldf', MOVE 'sysft_NPublic' TO 'd:\MSSQL.1\MSSQL\MyBase_2.NPublic', MOVE 'sysft_NStates' TO 'd:\MSSQL.1\MSSQL\MyBase_3.NStates', MOVE 'sysft_NHistory' TO 'd:\MSSQL.1\MSSQL\MyBase_4.NHistory'

El resultado fue el siguiente:

osql -E -SMyServer -iE:\CTM\CONFORME\RES_MyBase.SQL
1> 2> Processed 263904 pages for database 'MyBase', file 'MyBase' on file 1.
Processed 6 pages for database 'MyBase', file 'MyBase_log' on file 1.
Processed 1875 pages for database 'MyBase', file 'sysft_NPublic' on file 1.
Processed 287 pages for database 'MyBase', file 'sysft_NStates' on file 1.
Processed 4365 pages for database 'MyBase', file 'sysft_NHistory' on file1.
Warning: Wordbreaker, filter, or protocol handler used by catalog 'NPublic'
does not exist on this instance. Use sp_help_fulltext_catalog_components and
sp_help_fulltext_system_components check for mismatching components. Rebuildcatalog is recommended.
Warning: Wordbreaker, filter, or protocol handler used by catalog 'NStates'
does not exist on this instance. Use sp_help_fulltext_catalog_components andsp_help_fulltext_system_components check for mismatching components. Rebuildcatalog is recommended.
Warning: Wordbreaker, filter, or protocol handler used by catalog 'NHistory' does not exist on this instance. Use sp_help_fulltext_catalog_components and
sp_help_fulltext_system_components check for mismatching components. Rebuildcatalog is recommended.
RESTORE DATABASE successfully processed 270436 pages in 334.850 seconds (6.616MB/sec).

Para poder subsanar estos warnings debemos ejecutar las siguientes lineas:

EXEC sp_fulltext_catalog 'NPublic', 'rebuild';
EXEC sp_fulltext_catalog 'NStates', 'rebuild';
EXEC sp_fulltext_catalog 'NHistory', 'rebuild';

La salida mediante ejecucion osql/sqlcmd es la siguiente:

osql -E -SMyServer -dMyBase -iE:\CTM\CONFORME\REBUILD_MyBase.SQL

1> 2> 3> 4>

Dicha salida fue exitosa.

Un abrazo virtual a todos.