Thanks. Your info helped me figure out that I can have no connections in that database. So in Query Analyzer, to test, I have to connect to a different DB...

I have tried:

restore database [database] from device

as well as:

RESTORE DATABASE [database] FROM DISK = '\\box\d$\MSSQL7\BACKUP\database.BAK' WITH FILE = 1, STATS = 40, RECOVERY

and either way I'm getting the error:

Server: Msg...