RESTORE DATABASE is terminating abnormally

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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\trial_44testingc' is claimed by
'sysft_KB_SearchAssetsCatalog'(65540) and 'sysft_KB_SearchCatalog'(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_44testingc
select COUNT(*) as TOTAL from sysdatabases where name = 'trial_44testingc'
RESTORE FILELISTONLY FROM disk =
'C:\HostedTrialManagement\AppSource\db\43_trialmaster'
RESTORE DATABASE trial_44testingc FROM disk =
'C:\HostedTrialManagement\AppSource\db\43_trialmaster' WITH RECOVERY , MOVE
'43_trialmaster' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc.mdf', MOVE '43_trialmaster_log'
TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc.ldf', MOVE
'sysft_KB_SearchCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc', MOVE
'sysft_KB_SearchTicketsCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc', MOVE
'sysft_KB_SearchTicketsCatalog2' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc', MOVE
'sysft_KB_SearchAssetsCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc'

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

Any ideas?

TIA
Jake



.

Relevant Pages

  • Re: RESTORE DATABASE is terminating abnormally
    ... select COUNTas TOTAL from sysdatabases where name = 'trial_44testingc' ... RESTORE DATABASE trial_44testingc FROM disk = ... '43_trialmaster' TO 'C:\Program Files\Microsoft SQL ... RESTORE DATABASE is terminating abnormally. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: database problem
    ... BACKUP DATABASE db TO DISK = '' WITH INIT ... RESTORE DATABASE db FROM DISK = '' ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • RESTORE DATABASE is terminating abnormally.
    ... I am getting the rather odd error below; ... RESTORE DATABASE is terminating abnormally. ... RESTORE DATABASE trial_44testingc FROM disk = ... '43_trialmaster' TO 'C:\Program Files\Microsoft SQL ...
    (comp.databases.ms-sqlserver)
  • restoring the database has failed
    ... WITH -- Norecovery, ... STANDBY = 'c:\undo.ldf', ... MOVE 'logship_data' TO 'C:\Program Files\Microsoft SQL ... RESTORE DATABASE is terminating abnormally. ...
    (microsoft.public.sqlserver.server)
  • Re: Shared Disk and Active Node in SQL 2000
    ... I would place whatever local disk file you have on a clustered file share resource. ... Principal SQL Infrastructure Consultant ... point in time there will be only one active node that hosts SQL instance. ... The application connects to SQL instance and runs T-SQL query "select * from ...
    (microsoft.public.sqlserver.clustering)