ya thats right...

ok then thanx a lot.....

if i have any probs will get back to u...

bye..

-Abhishek.

Thanks a lot David...

ya above info is really useful....

but i am mostly interested in when to take backup? means what are conditions which will tell me like "take backup coz...

ok thanx a lot..

I think this will help.and almost done with this.

by the way are these two things only tell us that we have to take backup of SQl Server...

ok thats right. i agree with you.

but u r talking about Service stop and if service is Stopped we can restart it i think no need to take backup of...

ok its like this

I want those event ID which will let me know that server is going down so that i can backup that SQL server before going down using...