All the other databases restored successfully.
Any ideas?
just check if you are accidentally using the db in the management studio.....proceed as follows,
use master
go
then perform the restoration as usual....cool
fyi
http://technet.microsoft.com/en-us/library/ms156421.aspx