Working Environment Types
1- Production
2- QA
3- Development
Database Restore Types
1- Full Backup
2- Differential
3- LOG BACKUP
Process
- with Standby– Read only Database will be restored
-with norecovery- when we required to restore the data of full and differential backup only
-with recovery- when we required to store the database till crash time
1- Norecovery- Full Not Access
2- Norecovery- Differential not Access
3- Recovery- Log Backup Access
Info -MSDB database
RestoreFile
RestoreFileGroup
RestoreHistory
DATABASE BACKUP-
FULL-
Backup DATABASE SAWAN TO DISK=’SAWAN_FULL_BACKUP_07_06_2022.BAK’ WITH INIT
DIFFERNTIAL -
Backup DATABASE SAWAN TO DISK=’SAWAN_DIFF_BACKUP_07_06_2022.BAK’ WITH DIFFERENTIAL, INIT
LOG BACKUP-
BACKUP LOG SAWAN TO DISK=’SAWAN_LOG’ WITH NO_TRUNCATE
RESTORE
1- RESTORE DATABASE SAWAN FROM DISK=’’ WITH NORECOVERY
File Group Backup
Split
Mirrod
Copy only Backup
DR Plan
1-Loggshipping
2-Mirroring
3-Aloways On
4- Clustering
5-Replication
ITIL-SLA
