Dear Friends,

I too don't know the exact problem, what I am predicting is we are having 2 instances and I...

Dear Friends,

I got the solution for that one, its SQL problem, I don't know whether the solution is correct or not,now my database is working...

Dear Friends

when i check my DB by this query it is showing as Suspect

select databasepropertyex('apdb','STATUS')

and my common DB is not appearing,...

Hello Sir,

ours is SQL server standard edition and we are using only one instance cause it is production server and it is x86.and how to check how...

when I checked into the log files i got some message like..

2009-04-21 14:28:24.96 spid27s Starting up database 'DUMMY'.

2009-04-21 14:28:26.84 spid4s Recovery...

Dear Friends,

Thanks for your valuable response,

here i am giving some more details,

my database is located at D drive and it is having 22GB space,

and mainly...