SQL Server:?

Short answer: SQL Server Agent: Use SQL Server Agent to schedule backup jobs.

Example code

Create a backup job in SQL Server Management Studio (SSMS) to run daily, weekly, or at specific intervals. Script for automated backups: BACKUP DATABASE MyDatabase TO DISK = 'C:\Backups\MyDatabase.bak';

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.