Try to run DBCC CHECKDB on the original DB

>After restoring a Backup from our Application the BD stays in some strange state. Nothing could be done with it and the error message is "DB is still restoring (or something like this). Even with SSMS I only could drop DB, create a new one and then restore the backup.
>The strangest thing is that this is happened only on one server and I have no clue where I should look.
>
>Restore is executed from a SP and there are no errors returned from it.
>
>The executed command is:
>

>RESTORE DATABASE @BASE_NAME
>        FROM  DISK = @FILE_NAME
>              WITH  FILE = 1,
>              MOVE @LOGICAL_NAME TO @TODB,
>              NOUNLOAD, REPLACE
>

>where all variables has the right values :-)
>
>SQL Server 2008 on Windows Server 2008 both are 64 bits.
>
>BTW the message is:
>

>The database ...... is marked RESTORING and is in a state that does not allow recovery to be run.
>

>
>TIA