Hello Sir,
                    I am getting this message for all the other databases also. I closed all the existing connections but...

No I mean sorry that i was not specific

I just want to know that can i write a

procedure with the help of which i can take the

backup of all...

thnx a lot for ur reply.Can we create a database and then restore the previous taken database backup and then by copying the required tables from that database.