restore database from backup

Hi all,
I want to restore My database from backup
restore database HKData from disk ='H:\HKData.DAT'
go
i got error at
Server: Msg 3154, Level 16, State 1, Line 1
The backup set holds a backup of a database other than the existing 'HKData' database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
________
SUBARU JUSTY SPECIFICATIONS

restore filelistonly from disk =
'H:\HKData.DAT' will tell you what database file it has. It might be holding multiple database.


RESTORE HEADERONLY
from disk =
'H:\HKData.DAT' will tell you what database file it has. It might be holding multiple database.


I never saw somebody use .DAT for backup files. Are you sure it is a backup device or file?

Hi Mak,
restore filelistonly from disk =
'H:\HKData.DAT'
I got
PrimaryDev C:\Microsoft SQL Server\MSSQL\data\contacts_primary.mdf D PRIMARY 419430400 524288000
secondaryDev C:\Microsoft SQL Server\MSSQL\data\contacts_secondary.ndf D PRIMARY 209715200 35184372080640
LogDev c:\Microsoft SQL Server\MSSQL\data\contacts_log.ldf L NULL 104857600 35184372080640
RESTORE HEADERONLY
from disk =
'H:\HKData.DAT'
I got
NULL Pubs test backup 5 NULL 0 1 2 SERVER-ND3SGP2L\project SERVER-ND3SGP2L HKData 539 2004-10-27 12:26:50.000 1851904 26000000737400001 26000000737600001 26000000737400001 26000000610700002 2004-12-29 14:05:57.000 2004-12-29 14:05:57.000 52 228 1033 196609 80 4608 8 0 194 SERVER-ND3SGP2L 0 {8E076AF5-94EA-4726-A6EE-AE7A30D6A73C} {01C09242-19EC-4B73-AE47-B0A313D18E73} SQL_Latin1_General_CP1_CI_AS
wha tmistake I make!!
Thank you
________
Sauber F1.06

If you like to restore db to one with different name, you can use 'with replace' option in restore statement.

I think the problem is when I doing back up My SQL on c driver, now for some security reason, I have to restore anthing On my Pc, I want to move it to D driver, I got problem.
I try both

restore database HKData from disk ='H:\HKData.DAT' with replace,
move "HKData_Data" to "D:\Microsoft SQL Server\MSSQL\Data\HKData_Data.mdf",
move"HKData_Log" to "D:\Microsoft SQL Server\MSSQL\Data\HKData_Log.ldf"
go
and
restore database HKData from disk='c:\Microsoft SQL Server\MSSQL\data\contacts_primary.mdf ',
disk='C:\Microsoft SQL Server\MSSQL\data\contacts_secondary.ndf',
disk='C:\Microsoft SQL Server\MSSQL\data\contacts_log.ldf' with replace
it did not work.
Thank you for any help!!
________
Honda RA107 history

Hi Mak,
I think your right, I check by RESTORE HEADERONLY if I got back up type =1, I can restore it, but the problem is most of my database data type have kack type =5, I guess the reason is I replace the backup. what can I do now??
Thank you
________
Macintosh games

You can't restore db from .mdf file since it's db data file not db backup file.

You can attach the .mdf db file though. No need to restore.

May not work without .ldf file.