• AndrewSQLDBA (2/19/2010)


    Are you placing the backup files on the same box? If so, why even bother, if that box dies, so do your backup files. Have SQL place the backups on another drive on another box.

    Generally backing up across the network is a poor idea because of the speed of the network and the possibility of a single network glitch causing the entire backup to fail.

    Backup local, copy remote.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass