SQL Server Performance

backup of database in public network system

Discussion in 'SQL Server 2008 General DBA Questions' started by cupoflife, Dec 2, 2010.

  1. cupoflife New Member

    hi
    i have to take backup of database in public network system..

    that backup file should be in my system..i.e local network system.

    share folder is not accessing..

    so is there any other way?
  2. RichHolt New Member

    [quote user="cupoflife"]
    that backup file should be in my system..i.e local network system.

    share folder is not accessing..

    so is there any other way?
    [/quote]
    You could probably find a workaround for writing the backup to UNC share, but don't do it. Your best bet is to write the backup to a local volume on the server, then copy it over the network to the remote storage location. I use this method frequently. If the backup files will be large, I suggest using RoboCopy in restartable mode (so it can recover if stomething stops it before completing the transfer).
    -Rich

Share This Page