Question on Backup plans:
1.What is full, differential and transaction log Backup in SQL Server, and how do they interact with each other?
2. How many Recovery model exist in SQL Server, and their role in the Backup strategy?
3. How does the Transaction log backup maintain log space in different recovery models?
4.In which system databases you can not Backup Transaction logs?
5. What is the differential and incremental backup in SQL Server?
6. What is Point-in-Time recovery in the SQL Server?
7. What is Copy-Only Backups feature in SQL Server?
8. Which System databases can not be backed up at all?
9. What is the Tail-end Transaction log backup, and how is it performed?
10. How is file or filegroup Backups helpful for very large databases?
No comments:
Post a Comment