i need to create job schedule that backups the database from my local server to remote pc.i can do only backup in local machine.can any one please help to me get backup of database from local server to remote pc. looking forward for quick and positive response.
Thanks for your response Khtan. But acutally i want to have my database backup be done by using maintainace plan where i have created a backup job with schedule. And this schedule get backup of my database in my pc only.so i want that backup to be done in some other pc as well.how to give path of that very remote pc.also let me remind you that sql server 2000 is being installed in my pc only not in remote pc.i want to use remote pc just to have backup only.
Do you mean a regular overnight job i.e. backup the database and then move the file after, if so i would look at creating a ssis package to backup the database and then use the file system task to move the file to the new required location