there is a db in emergency mode,which i was told to make it "normal". in the enterprise manager i can not see any objects(like tables, users and stuff). in the guy's computer, i connect to the server via toad, and copied all the tables and users and functions etc.
dbcc checkdb returned 0 errors. and after getting all the data i can get, i typed
alter database 'name' set online . which changed nothing, the db was still in emergency mode.
i am not familiar with all those db modes, so i appreciate aany help i can get.
right now, db properties show that its in multi user mode, and still in emergency