Post reply

Taking Backup from remote server database

  • July 29, 2009 at 11:09 pm

    #137039

    I need to take backup from remote server database to my local machine. I searched on google and could not found out. Please let me know how do I proceed with it?

  • July 30, 2009 at 1:29 am

    #1032216

    arun (7/29/2009)

    I need to take backup from remote server database to my local machine. I searched on google and could not found out. Please let me know how do I proceed with it?

    take the backup on the server and then copy to local machine(preferred)

    or create a shared folder on ur local machine and take backup directly there.


    Pradeep Singh

  • July 30, 2009 at 7:01 am

    #1032358

    I could not take backup on the remote server as I have only FTP access to it. Whereas I transfer data from my local server(sql server 2000) to remote server (Sql server 2005 > sql server management Studio Express) through DTS Scheduler. But when I transfer data from remote to my local machine through DTS, data moves but I am not able to schedule it. It throws an error "[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_help_job', database 'msdb',schema 'dbo' ".

    Please let me know if anyone knows.

  • August 5, 2009 at 9:16 am

    #1034875

    as i

  • April 1, 2011 at 12:50 am

    #1306305

    Hi check the post - it may help you. http://narsimlusblog.blogspot.com/2011/03/scheduling-backup-to-remote-computer.html

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply