RESTORE DATABASE is terminating abnormally.

[GitarJake]

Hello,

I am getting the rather odd error below; hope you can help.

RESTORE DATABASE is terminating abnormally. File 'C:\Program Files\Microsoft
SQL Server\MSSQL.1\ MSSQL\Data\tria l_44testingc' is claimed by
'sysft_KB_Searc hAssetsCatalog' (65540) and 'sysft_KB_Searc hCatalog'(65537 ).
The WITH MOVE clause can be used to relocate one or more files.

I get this from an app our company uses to programatically restore
databases. Below are the queries we are using:

Create database trial_44testing c
select COUNT(*) as TOTAL from sysdatabases where name = 'trial_44testin gc'
RESTORE FILELISTONLY FROM disk =
'C:\HostedTrial Management\AppS ource\db\43_tri almaster'
RESTORE DATABASE trial_44testing c FROM disk =
'C:\HostedTrial Management\AppS ource\db\43_tri almaster' WITH RECOVERY , MOVE
'43_trialmaster ' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc.md f', MOVE '43_trialmaster _log'
TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc.ld f', MOVE
'sysft_KB_Searc hCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc', MOVE
'sysft_KB_Searc hTicketsCatalog ' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc', MOVE
'sysft_KB_Searc hTicketsCatalog 2' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc', MOVE
'sysft_KB_Searc hAssetsCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc'

This had been working great until I made some updates to the table structure
of the db and created a new backup.

Any ideas?

TIA
Jake

[Erland Sommarskog]

Re: RESTORE DATABASE is terminating abnormally.

GitarJake (spamaintme@oz. net) writes:

I am getting the rather odd error below; hope you can help.
>
RESTORE DATABASE is terminating abnormally. File 'C:\Program
Files\Microsoft
SQL Server\MSSQL.1\ MSSQL\Data\tria l_44testingc' is claimed by
'sysft_KB_Searc hAssetsCatalog' (65540) and 'sysft_KB_Searc hCatalog'(65537 ).
The WITH MOVE clause can be used to relocate one or more files.

I would not say that this is particularly odd, given:

'sysft_KB_Searc hCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc', MOVE
'sysft_KB_Searc hTicketsCatalog ' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc', MOVE
'sysft_KB_Searc hTicketsCatalog 2' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc', MOVE
'sysft_KB_Searc hAssetsCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\ MSSQL\Data\tria l_44testingc'

You are trying to place three logical files on the same physical file. That
cannot work out well.

Seems like you need to talk with the person/vendor who wrote the app
that runs your RESTORE commands.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx