0 What are the different types of Filebackup options? (SQL)

All data and objects in the database, such as tables, stored procedures, triggers, and views, are stored only within the following operating system files:

Primary
This file contains the startup information for the database and is used to store data. Every database has one primary data file.

Secondary
These files hold all of the data that does not fit in the primary data file. If the primary file can hold all of the data in the database, databases do not need to have secondary data files. Some databases may be large enough to need multiple secondary data files or to use secondary files on separate disk drives to spread data across multiple disks.

Transaction Log
These files hold the log information used to recover the database. There must be at least
one log file for each database. File groups allow files to be grouped together for administrative and data allocation/placement purposes

Rules of Files and Filegroups
Rules for designing files and filegroups include:

1. A file or filegroup cannot be used by more than one database. For example, file sales.mdf
   and sales.ndf, which contain data and objects from the sales database, cannot be used by any other database.
2. A file can be a member of only one filegroup.
3. Data and transaction log information cannot be part of the same file or filegroup.
4. Transaction log files are never part of any filegroups.
   

Types of BackUP

1. Database
2. Transaction log
3. Differential
4. Filegroup & Backup