cancel
Showing results for 
Search instead for 
Did you mean: 

Snapshot/Off-host fo SQL

Alexey_Shamrin
Level 3
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
3 REPLIES 3

zippy
Level 6
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
Level 3
Jim,
Why "if you snap it to the Master server"? May be any Media-server? Or Off-host Alternate Client?
Alexey

zippy
Level 6
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