Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you want to take advantage of distributing I/O overhead for a large database, select striped files, and select backup locations on different local disks.

When backing up SQL Server 2000 databases, consider using as few striped files as possible since a high number of striped files can significantly degrade performance due to SQL Server memory allocation.

How do you handle errors encountered while writing to the network during a backup?

...

...