Team,
I setup a separate SQL instance on a server to install the impresario database. I have run into two different errors.
1. I run:
CREATE DATABASE [Impresario]
ON
(NAME = Impresario_dat,
FILENAME = N'F:\MSSQL\DATA\Failover Data Files\impresario.mdf',
SIZE = 3MB)
LOG ON
(NAME = Impresario_log,
FILENAME = N'G:\MSSQL\LOGS\Failover Log Files\impresario.ldf',
SIZE = 2MB),
(FILENAME = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\MSSQL\FTData\Inventory_Search')
for Attach
I receive this warning:
Warning: Identity or last population complete time of full-text catalog in directory 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\MSSQL\FTData\Inventory_Search' does not match database 'Impresario'. The full-text catalog cannot be attached.
I move on to restore the database from production and receive this error:
The file "sysft_Inventory_Search" failed to initialize correctly. Examine the error logs for more details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
The error log states:
The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'DeleteTree' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Inventory_Search\MssearchCatalogDir' at 'fulltext.cpp'(1740).
I followed the steps again without attaching the full text catalog but again I cannot restore this database.
Has anyone else had this issue and have a solution?
Many thanks!
Naomi Williams
1,
After a long time research, finally, I understood what happened on your machine.
you setup your "Full Text catalogs " in a custom way.
it is not in a default setup.
so you need to do quite a bit additional work to restore impresario database.
the solution is to redo the "Inventory_search", leave the "Catalog location" empty.
then you will not have this FTData crab again.
2,
If you want to keep the current setup,
you can run this to rebuild the "Inventory_Search".
USE
[impresario] GO
GO
ALTER
REBUILD