...
| Location Type | Actions |
|---|
| Single File | - Choose if you want to Overwrite or Append the existing archive file, the name of the Primary Archive file, and the Mirror Archives Filenames.
|
| Striped Files | - Choose if you want to Overwrite or Append the existing archive files.
- Specify as many filenames as the number of striped files you want.
- 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.
|
| Tape (Tivoli Storage Manager) | - Choose if you want to Overwrite or Append the existing archive file.
- Enter the path to the TSM configuration file (High Level, Low Level, and Management Class).
- Specify the TSM Client Settings (Client File and Connection Settings). For these settings, you have to specify the name of the node you want to use, the password required to access the node, and the TCP/IP Server address and port.
|
| Data Domain | - Choose if you want to Overwrite or Append the existing archive file, the name of the Primary Archive filename, and the Mirror Archives Filenames.
|
| Amazon S3 Cloud | - Specify your Amazon S3 cloud storage options to be used for your backup. These options include:Access Key, Secret Key, Region, Bucket Name and File Size. For more information, go to Cloud Settings.
|
| Microsoft Azure Cloud | - Choose if you want to Overwrite or Append the existing archive file.
- Specify the information needed to access your Microsoft Azure cloud such as:File Name, Container Name, Azure Storage Account Name, and Azure Access Key. For more information, go to Azure Settings.
|
| Tape (Tivoli Storage Manager) Striped Files | - Choose if you want to Overwrite or Append the existing archive file.
- Determine the path to theHigh levelprimary archive, its management class, and the information related to the TSM Client Settings (Client Options File, Node Name, Node Password, Server Address, and Server Port).
- Specify the number of striped archives and the details for each low levelarchive.
| Note |
|---|
Take into account that if the number of stripes is greater than the available sessions on TSM server, the backup fails with a message "sessions are not available on TSM". There is no available way for the TSM client to find out available sessions on the TSM server. |
|
...
If you want to take advantage of distributing I/O overhead for a large database, you can select striped files and choose 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?
...