Backup and restore your Microsoft SQL Server database

If you are someone who works with Microsoft SQL Server a lot, knowing how to backup and restore your SQL Server database is a must required skill. In this tutorial, I will be teaching you two methods (using SQL Server Management Studio and T-SQL script) to backup and restore SQL Server database.
T-SQL scripts used in this video:
learndataanaly...
Buy Me a Coffee? Your support is much appreciated
Paypal Me: www.paypal.me/...
Venmo: @Jie-Jenn
More tutorial videos on my website
LearnDataAnaly...
Check out my gears here on Amazon:
www.amazon.com...

[@gykg3202]

Thank you very much! Very helpful!

[@caesarsungdong6722]

You are the best. Thank you

[@ahmedh2482]

Awesome,
Thanks

[@afdinh0]

good video, thank you!!!!

[@nayzawmoe]

Is there a way to put current date in the backup file name with T-SQL script and run the script with Task Scheduler?

[@jiejenn]

Pretty sure you can. I remember in SQL server it was done via agent.

[@bhagyashri6657]

I am not able to get the backup of DB(through T-SQL script) , Error -'Statement 'BACKUP DATABASE' is not supported in this version of SQL Server. Can you please mention which version of SSMS are you using? (I am using SSMS 19.0.1) . Also backup and restore option is not there in this version.

[@jiejenn]

You will have to figure out from the official documentation website.

[@calvinkoay1939]

Hi, when dropping database, I always get error like 'Cannot drop database because it is currently in use. What's the problem?

[@jiejenn]

Probably because you (or one of the scripts) are currently connecting to the databas you are trying to drop. Select a different database, then try drop the database again.