Forum Discussion

Alexey_Shamrin's avatar
Alexey_Shamrin
Level 3
19 years ago

Snapshot/Off-host fo SQL

Hello!
There is a SQL-server with classical stream-based method of backuping. However backup duration exceeds the maximal time. A unique decision - to pass to file-based methods backuping, Local Snapshot Backup or Off-host Alternate Client. Сorrect?
Somebody has successful experience of introduction of the given technologies?
Whether they give an essential prize at greater sizes of bases? (up to 1Tb)
Thanks for advice and the help
7.1.x and Earlier
Backup and Recovery
NetBackup
  • zippy's avatar
    zippy
    Level 6
    19 years ago
    Alexey,

    If you have the ability to snapshot the database then I would use it, very fast if you snap it to the Master server, then back it up, you can drop a SQL licence to boot.

    Jim
  • Alexey_Shamrin's avatar
    Alexey_Shamrin
    Level 3
    19 years ago
    Jim,
    Why "if you snap it to the Master server"? May be any Media-server? Or Off-host Alternate Client?
    Alexey
  • zippy's avatar
    zippy
    Level 6
    19 years ago
    Alexey,

    These are all a possible solutions, I have 10 TB of Databases being snapped to my master and to a SSO server, and all backups complete in 6 hours.

    JD