Continuing from my earlier post about backup strategy I will explain on how to restore database from full, differential and log backups.
Assuming we have four backup files on disk which are testdb_full.bak, testdb_differential.bak, testdb_log_1.bak, testdb_log_2.bak. These files were created during backup processes with its sequence are full, differential, first log and second log.
We name the database with ‘TestDB’.
First of all open SQL Server Management Studio and restore the full backup with norecovery option with below syntax:
Backup and Restore strategy is always important for application that uses database intensively. A good database administrator must have known that if he/she doesn’t have good strategy then significant data loss might be occur.
DB Administrator has a task to minimizes data loss.
Your backup strategy has a type of backups, frequency and how fast it requires. Off course, it is also depends on hardware specifications. On the other hand, restore strategy has a way to restore database from backups you created before and testing it.
Frequent backup can be scheduled automatically by SQL Server schedule job. To activate SQL Server schedule job you need to start sql server agent service.