Return
-
Title
Impossible to restore LiteSpeed backup: File 'E:\Data\XXXXX\YYYYY\test.mdf' is claimed by 'test_2'(3) and 'test'(1). -
Description
Getting error below when trying to restore a backup created by LiteSpeed:
Unexpected termination on thread: 3, Return code: x80770004 RESTORE DATABASE is terminating abnormally. File 'E:\Data\XXXXX\YYYYY\test.mdf' is claimed by 'test_2'(3) and 'test'(1). The WITH MOVE clause can be used to relocate one or more files.
-
Resolution
RESOLUTION
The original database locations might be wrong.
The WITH MOVE clause can be used to relocate one or more files.
Please refer to the SQL Server Transact-SQL backup and restore documentation for the syntax and usage.
The supported formats are:
@with='PARAMETER'
@with='PARAMETER=''accepted_value'''