[RESOLVED] MS SQL Server 2000 restore problem

Hi.
See picture in attachement.
My sql server is installed in C:\Program Files\Microsoft SQL Server\MSSQL\ instead C:\Programas\Microsoft SQL Server\MSSQL\ . How do i use the WITH MOVE ??
TIA
Jorge

Code:

---

restore database mindsolution
from disk 'c:\...mindsolutions.bak'
with move 'mindsolutions' to 'c:\program files\microsoft sql server\mssql\data\mindsolutions.mdf',
move 'mindsolutions_log' to 'c:\program files\microsoft sql server\mssql\data\mindsolutions_log.ldf',
REPLACE

---

If the database does not exist, then you can skip the REPLACE keyword.

Dropped mindsolutions bd and tried this

Code:

---

RESTORE DATABASE mindsolutions
  FROM DISK = 'c:\mindsolutions.bak'
  WITH MOVE 'mindsoltions' TO 'c:\program files\microsoft sql server\mssql\data\mindsolutions.mdf',
  MOVE 'mindsolutions_log' TO  'c:\program files\microsoft sql server\mssql\data\mindsolutions_log.ldf',REPLACE
GO

---

but get error : Server: Msg 3234, Level 16, State 2, Line 7
Logical file 'mindsoltions' is not part of database 'mindsolutions'. Use RESTORE FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.

You have a typo in the first MOVE: minsoltions. missing a "u"...

OK thanks