Full Backup is a complete copy, which stores all the objects of the database: Tables, procedures, functions, views, indexes etc. Having a full backup, you will be able to easily restore a database in exactly the same form as it was at the time of the backup.
Types of Backup in SQL server.
https://youtu.be/zhtpwsCapn0
Contents in the video
1. What is full backup ?
2. How to take full backup of database using GUI and T-SQL query?
3. What is append and overwrite (noinit and init) ?
4. How to view appended backup files that are present in single backup file ?
Comments are closed.