DB Unusable after Restore

[Guest_imported]

I tried restoring a db from backup file, after restoring, when I tried to see the prop's of the db, it gives me error message - the db is in middle of the restore operation, but I could see the completed message from sql QA. Moreover in Ent. Mgr. I could see 'loading' message next the restored database. How do I open and work with the restored db. Any help would be greatly appreciated.

Query :
restore database productsUK from disk = 'c:\lehman\bakproductsUK' with norecovery, move 'stageComputers_Data' to 'd:\mssql7\data\blabla1.mdf', move 'stageComputers_log' to 'd:\mssql7\data\blabla1.ldf'

Result :

Processed 5048 pages for database 'productsUK', file 'stageComputers_Data' on file 1.
Processed 1 pages for database 'productsUK', file 'stageComputers_Log' on file 1.
Backup or restore operation successfully processed 5049 pages in 7.294 seconds (5.669 MB/sec).

 

[tlbroadbent]

The "norecovery" tells SQL Server not to recover the database. "norecovery" should only be used if you have additional restore statments to process as in the case of differential or transaction log restores. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.