i have MSsql server 2000 in my server.I have MSsql server 7 installed in my local machine which has access to internet.I would like to take a database backup from my server remotely.
In order to do that i tried to connect MsSql server from my local machine using ip number sql server user name and password.But it is not successfull.Do i need to have the same MsSql server 2000 in my local machine.

Could any one suggest me a way to achieve this.

Your help will be much appreciated.Thanks in advance.