Metal complexes of Schiff bases derived from isatin monohydrazone and 3-(2-hydroxyphenyl)-1-phenyl-1H-pyrazole-4-carbaldehyde is reported and characterized by elemental analysis, conductance and magnetic measurements, IR, UV-Vis, mass, 1H NMR, as well as by ESR and XRD studies. The low values of the molar conductance indicate non electrolyte type of complexes. Based on spectral data and magnetic moments, an octahedral geometry may be proposed for Co(II), Ni(II) and Cu(II), complexes while a tetrahedral geometry for Zn(II), Cd(II) and Hg(II) complexes. The Schiff base and its metal complexes have been screened for their in vitro antibacterial and antifunal activities by cup plate method. The DNA cleavage activities of all of the complexes were studied by the agarose gel electrophoresis method. The Schiff base and its metal complexes has been studied for their antioxidant activity. The results of bioassay revealed that, the metal complexes are active than the free ligand and their biological activity increases on complexation.