Stop It Now - Offline-Detach and Drop - SQL in Sixty Seconds 103

There are few things better not tried on your production server. I strongly suggest that you watch the entire video before coming to any conclusion.

Do not run any of the commands without understanding their implication. They can damage your server.

Let us understand the difference between Offline, Detach and Drop database!

#SQLServer #PerformanceTuning #SQLAuthority

0:00 Introduction
0:25 Real World story
1:03 Demonstration for offline-Detach and Drop
1:20 Offline Database
2:26 Detach Database
3:07 Warning - Don't Do it!
3:21 Drop Database
4:00 Summary

[kulwantsingh]

Thanks Pinal, its bringing the real life problem solving techniques to this platform ...Interesting example.

[achilleskocaeli]

Thanks Pinal, . I want to do that in production Server tomorrow 😊

[keep_digging]

Great content Pinal healthy warnings are always welcomed, keeping us alert

[savananjaria]

Thanks for bringing the real life problems and their solutions to this platform. That's quite educating...!

[samirkhimani]

Hi Pinal,
Thanks for sharing information.
What is the best way to delete log files if it is using lots of space in production?

[shovon]

Hi Pinal, I like your videos a lot. Could you please publish restoring master db on its corruption?

[sarithap]

Hi Pinal,
I want to detach the database which is offline already. I believe it has to be bought online before detaching. Is there a way we can avoid connections to the database in any way when it is brought online?

[kulwantsingh]

Hi Pinal Sir - Can you possible one video tutorial on Latches?

[ankushdesai]

For moving mdf & ldf files from one location to another can we use below method :
1. Take backup of DB
2. Drop that DB
3. Restore that DB by giving new location for mdf & ldf files.

Can we do this ?

[mandarhadke]

Hey Pinal Sir - Can you please do a video tutorial on Linked Server?

Thanks in advance.