SQL Server DBA Tutorial 33- How to Take Database Offline and Bring it Online in SQL Server

In this video you will learn how to take database offline and bring database online using SQL Server Management Studio as well as using T-SQL script. It also demonstrates real time scenarios when it is best to attach and detach sql server databases.
Blog post for script used in this video
sqlage.blogspot...
Visit our website to check out SQL Server DBA Tutorial Step by Step
www.techbrother...

[@venkyvenkatesh1474]

You guys are like master Dhronacharya to many students like Akalavya. we can learn as much as fast with perfection... thank you😇😇

[@binyammamo6454]

Thank you as always!

[@kingming869]

In real world situation, Option 1 should never be used, unless you know for sure there's no users on it at all. otherwise it will just hangs in "In progress" when setting DB Offline. Always use option 2, safer.

[@best07deb]

Thank you for the video. Have one small question, What is need of bringing a Database offline?

[@abodalmalik9990]

thank you

[@TechBrothersIT]

You are welcome!

[@Faisal1504]

Thanks

[@TechBrothersIT]

Welcome

[@andreigiubleanu]

On the point!

[@lakshayarora3935]

Hi TechBrothersIT. Your videos are awesome. Everything is explained step by step and in a very good and easy manner. However, just wanted to know if these 180 videos(if I am not wrong) are sufficient for me to excel in DBA field since I am currently looking to work as a DBA in near future. If any additional videos are required, please please upload it. I am eagerly waiting for it.:)

[@TechBrothersIT]

Hi, Thanks for liking our effort. 180 sounds right number. I will also suggest you to watch the videos on sql server 2016. here is the link. www.techbrothersit.com/search/label/SQL%20Server%202016

[@lakshayarora3935]

@@TechBrothersIT Thanks a lot :):)