Hi,

Thanks for your reply..

I have mapped the application server to sql server 2000 with just a change in database server ip address. There it's working perfect.

Is this the issue...

HI,

The db in question is accessalable and online. Previously a different login was given but I read at several places that it might be access issue hence i logged in...

HI Markus Bohse

Thanks a lot the link was really usefull.

Your solution will work only when I can predict a downtime.

My query is for unplanned system crash. Hence I guess I need some other solution.