How to restore .bak file in SQL Server Management Studio 2019
Vložit
- čas přidán 16. 05. 2020
- How to open and import a .bak file to a database in SQL Server Management Studio 2019
Step 1: Copy your own .bak file that you downloaded
Step 2: Go to "OS(C:)/Program Files/Microsoft SQL Server/MSSQL 15.MSSQLSERVER/MSSQL/Backup" and then paste the .bak file
Step 3: Go back to SQL Server Management Studio, click on Databases and right-click and choose Restore Files and Filegroups
Step 4: At "Destination to restore" enter the database name of the .bak file. At "Source for restore" click "Form device" and click the 3 dots to select the .bak file from your device
Step 5: Click Add then it will automatically detect where you have pasted the file in the Backup folder, just click on the .bak file you need to open. Then click OK and OK
Step 6: In the "Select the backup sets to restore" section do not forget to check the Database Backup then click OK and when Database restored successful click OK
Step 7: click refresh or F5 key and you will see your database
----------------Follow us-----------------
Twitter:
/ cbtechnologies - Věda a technologie
4 years later and you're still helping people. This worked. You're the man.
voy a llorar, mil videos y este era el que necesitaba, gran explicacion, asi sea simple no lo sabia T.T
Excellent mate, really helpful, Thank you so much. You got one more sub.
Silently Thanks Man
so useful! thanks a lot, stay blessed!
Thank you Soo much you just save my company million .
excellent, helps a lot, thanks
Thanks For Making This Video
NICE VIDEO, BRO!!!! Obrigado
Thank you!! 😀😀
Thank you so much!
Thankyou mate 🙂
It Worked , Thanks
tenga su like, buen hombre
Thnks buddy 👍
helps a lot mate. Really appreciated. Thanks
Thanks a lot!!
excelente Gracias
thanks it's great
I’m using the same version but I can’t open the backup folder!
Thanks
thankkkkk uuu
omg ty!!!!
yes, it works.
excellent
At 1:18, when i added bak file from Program files, i didnt get Restore, Name , File type, type, File Logical Name, Server etc in the "select the back up sets to restore"
Maybe you have improperly backed up the .bak file from another computer, causing the .bak file to fail to open or there is no data available to restore on another computer
@@ComputerBerry Yes, thats right, file was imcompletely downloaded 👍👍. Thanks for your reply
thanks berry
awesomeness
You are the best! Thank you
Thanks!
why the backup folder is not opening for me ? Pls anyone can suggest.
did you get the answer?
@@namratanagvekar6857 No
Muito bom !!!!!!!!!!!
why my backup folder isnt opening?
brooooooo !!!!!! thanks
🥰
thanks
yes its work
Good
🥰
Backup folder is not opening please help me sir 🙏
It may not work because you haven't backed up properly, there is a difference between versions
Restore fail
mssql15.mssqlserver\mssql\backup directory not exists
Thanks a lot!!