Versions Compared

Old Version 12

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Rivera

Saved on

Key

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

...

SQL Safe supports the following location types:

  • Single File.
  • Striped Files.
  • Tape (Tivoli Storage Manager).
  • Data Domain.
  • Amazon S3 Cloud.
  • Microsoft Azure Cloud.
  • Tape (Tivoli Storage Manager) Striped Files

What do you do if you do have an existing archive?

...

  • .

What

...

If you do not have an existing archive file, SQL Safe creates a new archive file to include the backup set. 

What actions do you have for each location type?

Location TypeActions
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.
Tape (Tivoli Storage Manager)
  • Choose if you want to Overwrite or Append the existing archive file.
  • Enter the path for the Primary Archive file (High Level, Low Level, and Management Class).
  • Specify the TSM Client Settings (Client Options 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 file, and the Mirror Archives Filenames.
Amazon S3 Cloud
  • Choose if you want to Overwrite or Append the existing archive file.
  • Specify your Amazon S3 cloud storage options to be used for your backup. These options include
:
  • File Name, Access Key, Secret Key, Region, Bucket Name,
Secret Key, Access Key, File Size, and Region
  • SubFolder(s) (Optional), Storage Class, and File Size. For more information, go to Amazon 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
  • clouds such as
:
  • File Name, Container Name, Azure Storage Account Name, Azure Access Key, SubFolder(s) (Optional), and Sector Type. 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 the High Level primary 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
  • Low level archive.
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.

What are striped files?

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.

...

Select Enable Network Resiliency and access the Network Resiliency Settings window where you can specify how often you want to retry when errors occur and after how much time the operation will fail. You can also configure how much time is allowed for the total retry time of the backup.

Info

This option is not available when backing up to tape using Tivoli Storage Manager.

What do you do if you do have an existing archive?

If the Archive Exist, you can select to Append it to an existing archived backup set or choose to Overwrite it.

What happens if you do not have an existing archive file?

If you do not have an existing archive file, SQL Safe Backup creates a new archive file to include the backup set. 

Tip

Keep in mind, the filename extension for all backups performed under the SQL Safe format are .safe and for all backups performed under the SQL server format are .bak.

How do you mirror your backups?

Mirroring your backups is available when you select Single File or Data Domain location type. Select Mirror Archives, then specify where you want the mirror copies to be stored.  

...

If you want to stop the backup operation when the mirror location is unavailable, select Abort backup if a mirror location reports a failure. 

Info

This option is only available when backing up to Single File and Data Domain. 

After selecting Once you select the location of your backup files, go to the Configuring click NEXT to configure options for your backup section. 



SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
Scroll pdf ignore
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResourcesLegal

...

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 | 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse