• dbhelp (6/2/2008)


    I don't think that would help me. That appears to backup the local database to a remote server. I am looking for a way to specify that the database I am trying to copy is on a different server, while backing up on the local server, through a job running on the local server.

    Thanks SQL ORACLE, You mentioned correct. You have to give the Correct network path. I have SSDS environment and I use the same to take a backup of the DB in other server AS SQL ORACLE mentioned above.

    First have mo make sure that file system have proper permission on it.

    \\abcdefg\$E\MSSQL\MSSQL1\Backup

    Manoj

    MCP, MCTS (GDBA/EDA)