I have some queries regarding backup and restore strategies.
I want to take Backup and Restore of Large Database approx. 60 to 70 GB and it is critical database in SQL Server.
Backup schedule approx. i decided,
- Full Backup every day
- Differential Backup every 2 or 3 hour
- Transaction-log Backup every 15 minute
Is this correct approach? if not then please suggest better option?
Which Recovery model is best suits ? (Simple, Full, Bulk-logged)
In case any of backup file(full backup file, differential backup file or log backup) has corrupted then what are the options to recover database quickly with minimum data loss?
THANKS in Advance...