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,
if you want to restore a database, you need to make sure nobody is connecting to it.
you can open the activity monitor and you can kill the process by right click it.
2,
if you restore a database with another copy (not its own backup), you need to tick the overwrite box through the option selection.
I will paste it in next post.
this forum only allow post one pic (and <64kb:-( )
have fun
you can create a new database name it "impresario"
(if you already have a impresario database go to next step)
right click the impresario database go to restore, then go to database, then choose "Device", pick up the db backup file, go back to the "options", select "Overwrite the existing database".
at this point, you can click the script dropdown list select "script action to new query window"
then the full script to do the restore work is there.
you can save it if you want to.( I never do this.)
3,
open the activity monitor check nobody is connecting to the impresario, ask them to logout.
4,
run the script, and wait.
In SQL view, restore database ends here.
5,
(For Tessitura application only,)
If you are doing the LIVE copy over to TEST, you need to do:
a,
run some script step up T_Default table.
b,
run the security check script,
c,
then run the dropping and create login in Tessitur Security tool.
d, try to login again.
That is all.
:-):-):-)