thanks for the reply.......

Iam using type 4 driver (sqljdbc) .......

If a query has to be executed, it has to be in transaction......

Or else is there any other way?

What do you mean by a "forced" database backup?

Sometimes, while executing the query i have encountered the following error

"some active connections.........."

So before going ahead, i need to close the active connections and then proceed further.......So, in such cases is it possible to make forced backup and restore...

Note: forced in the sense, complete the database operations irrespective of active connections