Re: RESTORE DATABASE is terminating abnormally

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

From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
Date: Thu, 19 Apr 2007 07:39:16 -0400

Can you try this?

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_44testingc1', MOVE
'sysft_KB_SearchTicketsCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc2', MOVE
'sysft_KB_SearchTicketsCatalog2' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc3', MOVE
'sysft_KB_SearchAssetsCatalog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\trial_44testingc4'

"GitarJake" <spamaintme@xxxxxx> wrote in message
news:j0zVh.17257$OT4.12355@xxxxxxxxxxxxxxx

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

References:
- RESTORE DATABASE is terminating abnormally
  - From: GitarJake

Prev by Date: Can't put duplicate words in different expansion sets?
Next by Date: Re: Fulltext Catalogs in SQL 2005 Express
Previous by thread: RESTORE DATABASE is terminating abnormally
Next by thread: Fulltext Catalogs in SQL 2005 Express
Index(es):
- Date
- Thread

Relevant Pages

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 ...
(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)