niladri.primalink (3/5/2013)
Then I need to take others help as the database is on Other server then I need to ask that person to take the back up and also will have take the back up file from him.
I take it that both of the database servers belong to your company.
Gail's (Gilamonster) solution is the obvious one to me as well. Backup, copy and restore.
If you do not have access to the server (and it belongs to your company) then ask for access - even if it is on a temporary basis- it appears you need it for part of your job. Then you can perform the whole task yourself with out having to call on one of your colleagues.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx