Post reply

Making a backup to a remote machine

  • November 20, 2004 at 5:40 pm

    #109619

    Is there any way of making a database backup to a remote machine without using a mapping to the remote machine folder???  I have adopted by now the scheduled task method to copy the scheduled backup to the remote machine using a mapping, but I would like another approach, like an utility, plugin or something like this to achieve this task.

    Thanks in advance,

    Felix

     

  • November 23, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • November 23, 2004 at 10:48 am

    #531257

    For some of my servers, I take differential Backup every hour, then copy this to remote machine using the below job:

    Job: Diffrential Backup of All databases & COPY

    STEP 1: Diffrential Backup of All databases

    STEP 2: Copy Diffrential Backup Database Files to  remote machine ussing this below code:   

    xp_cmdshell'xcopy E:\MSSQL2000\MSSQL\BACKUP\Differential\*DIFF.BAK \\REMOTE\BACKUPDRIVE\MSSQL2000\MSSQL\BACKUP\Differential /Y'

    GO

     

    Hope this Helps!!!

    .

  • November 23, 2004 at 2:34 pm

    #531303

    If you don't want to backup using drive mappings you should use UNC path naming conventions.  SQL server handles these much better than mapped network drives.  All you need to do is kick off a backup using this path.

    backup database northwind to disk='\\servername\share\filename.bak'

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

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