Full Backup in SQL server || Append & Overwrite backup file || Ms SQL



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.