[RESOLVED] MS SQL Server 2000 restore problem

[Asgorath]

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

[kaffenils]

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.

[Asgorath]

Dropped mindsolutions bd and tried this

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.

[kaffenils]

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

[Asgorath]

OK thanks