أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
http://www.bayt.com/fr/specialties/q/54931/what-is-the-best-scenario-for-database-backup/
Mirroring
or
sql clustering.
It's depending on the scenario
You can make Snapshot replication to replicate everything it's like a backup,
Merge replication used if you want server and client make changes in the database
Transactional to make one way replication
