BOL

recovery bring database online while norecovery leave it for further log resotred

inside there try .bat instead of bat. chekc event viewer and see if you see any more error. i am assumin gu have admin rights on box. and check this...

seem s more like installer issue. probably install installer again? you can try through .bat. check com objects also.

are u restoring over the network. what RAID is implemented. when u backup try creating partitioned backup. i usually setup 5 files. and then restore.

it kills all existing connection and roll back any transaction currently running against it.

humm weired. can u run sp_who2 and se who is connected to this. make sure you are not connected to it. if any application is connected to it ask...

looks fine but look at execution plan it will take long time and put load on disk . too many joins. reduce if you can or add...

ALTER DATABASE test01 SET SINGLE_USER WITH Rollback Immediate

ALTER DATABASE test01 SET MULTI_USER WITH Rollback Immediate

where is database name. you habve to connec tot master and then use it like this

alter database ---database name ----

what command you used .

did u put imeediate rollback

connect to reporting services in managment studio and it says edition and verion right there.

sql grab as much as it can . later if it need to relase it to other resources it will but in profmon under memory manager check to see target...

i would say make sure that both instance are not using dynamic ports. . if they are using dynamic then change them.

also its not do you see any...

if db offline noone can connect.

you mean you wan tto take it offline when user are connected.

use immediate rollback in your alter database command