How to Restore a Database in SQL Server || Permission required to restore a DB || SQL DBA
Vložit
- čas přidán 19. 06. 2021
- 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 : • Types of Backup in SQL...
b) Fullbackup : • Full Backup in SQL ser...
c) Differential Backup : • Differential Backup in...
d) Transaction Log backup : • Transaction Log backup...
e) Tail Log backup : • Tail Log Backup in SQL...
Roles in SQL server : • Server roles , Databas...
@righttolearnbk
superb explanation with demo, thank you so much for your contribution mate. Hope to watch more helpful content like this from your end.
I am beginner planning to change my career into DBA...I watched Backup and Restore videos. you explained really very well in understanding manner...in fact I enjoyed while learning. Thanks a lot:)
Great content sir thank you looking forward for more videos about sql
super sir .... you are a good teacher.. looking more videos of mssql.
than you for your videos, they are great
Great job please continue awesome videos
Nice explanation 👌👍
Nice video bro
I'm getting error 'No backupset selected to be restored' how do I fix this
Can you please provide more info about with recovery and no recovery
👍
In log backup commands log
backup extension is .TRN not .bak
Yah, it was a typo error
Restoration options like
With replace
With move
With stop at
Not discussed bro
👍