Database backup

Question

database backup types? what is the use of full database back? and why we take a back up?

Bhuvanesh Mohankumar · Answer

The whole world works to maintain data all software in turn work for data maintain maximum a software can do [Create/Update/Read/Delete] of data. It's very important to maintain data What will happen if all the Gmail data of yours is lost. All of sudden if your Bank account shows Zero balance and bankers say sorry data lost. Hope you understood about data backup. Azure helps even to replicate database in multiple location of world. Mark as answer if helpful.

Dharmesh Singh · Answer

Please see following link - I am sure it's helps - https://www.mssqltips.com/sqlservertutorial/6/types-of-sql-server-backups/ http://searchdatabackup.techtarget.com/tip/Data-backup-types-explained-Full-incremental-differential-and-incremental-forever-backup

Ipsita Sethi · Answer

The different types of backups that you can create are as follows: Full backups Differential backups File backups Filegroup backups Partial backups Copy-Only backups Mirror backups Transaction log backups