Home Forums SQL Server 7,2000 Backups Problems Backing up SQL 2000 over the network RE: Problems Backing up SQL 2000 over the network

  • The true issue is network connectivity and somehow I don't think a hotfix is going to cure that. One blip in the connection/Nic and the backup is worthless. Can you afford missing a backup here and there? I can't. If I need to get to a certain day/PIT and can't because of a network issue, who are they going to blame, the network admin or me? If local disk permits, backup local and copy across the network (or to tape). If local disk doesn't permit, add more disk or look at third party tools that'll compress the backups by about 75% (search this site for the various vendors and comments by posters). That's the recommended, and safest approach. Again, I cannot take a chance missing a backup, can you?

    -- You can't be late until you show up.