When restoring a database we will need exclusive access to the database, which means no other user connections can be using the database. If the database does not exist it will create the database and restore the files to same location specified in the backup. If the database already exists you can choose to overwrite the files or restore DB with another name using ‘with move’(relocate files). ::: Related Video links (Click below links to watch them) ::: a) Types of backup in sql server : https://www.youtube.com/watch?v=zhtpwsCapn0​ b) Fullbackup : https://www.youtube.com/watch?v=HOf7q2yF9g8​ c) Differential Backup : https://www.youtube.com/watch?v=otZE1nZoUM8​ d) Transaction Log backup : https://www.youtube.com/watch?v=QNeSP7bz24I e) Tail Log backup : https://www.youtube.com/watch?v=BYQvW3jKP0c Roles in SQL server : https://www.youtube.com/watch?v=gkCkX5ogyzI https://www.youtube.com/channel/UCQKSw_b_QI86aStl9CO1Bbw