TNWiki Article Spotlight: SQL Server Detach and Attach!


Hello and welcome everybody to our TNWiki Article Spotlight on Tuesday!

 

This is my first blog post after a long time! My last post was published here on August 22, 2017. It is slightly more than a year! Wow, I feel that many things changed! I even have a new signature icon which is really nice! Thank you Kamlesh Kumar for creating such a pretty icon!

We also have new processes! New authors and bloggers! And so many new articles published during this time! So, to find a good article for this spotlight blog post, I read several nice articles which I picked up from last few Monthly Guru Award Winners. I read each of them from start to the end.

After reading all of them I would like to talk about my favorite article
SQL Server: All about Detach and Attach operations and common scenarios where they may or may not work

published by Mohsin_A_Khan.

I really liked the way he explained the issues and their solutions. He did a great job on writing a very useful and well-organized article around the attach and detach operations in SQL Server. The article covers several real-world issues and provides practical solutions with clear notes, warnings, references, and workarounds where needed. The article has one of the highest issue density in the TechNet Wiki articles. Although he wrote about many issues I enjoyed the content association. Right after he brought up an issue, he told you what is the solution.

All the samples worked accurately on my test virtual machine. Albeit I didn’t find the example code on “alter database…modify file” section, but it explained very well. Moreover, in the section “When a log file cannot be rebuilt”, he put a note section that mentioned Paul Randal’s blog post which was very useful. Finally, in the conclusion section, he brought it to a good end!

In his article you will find solutions to the following issues:

  • Detaching and attaching a database
  • How to move a database that participating in Log Shipping?
  • Common scenarios where attach may or may not work
  • When SQL instance is cleanly shut down
  • When a single log file is missing
  • When multiple log files are missing
  • When a log file cannot be rebuilt
  • When the database is read-only
  • How log rebuild breaks the log backup chain

 


Saeid Hasani

Microsoft TechNet Wiki Ninja

BlogWikiProfile

 

Comments (6)

  1. Pete Laker says:

    Good choice. Thanks Saeid!

    1. Saeid Hasani says:

      Peter, I was lucky enough! 😉

  2. pituach says:

    It’s awesome to see you back here Saeid 🙂

    Great post, fun to read, and a nice choice for the weekly Article Spotlight

    1. Saeid Hasani says:

      Thank you Ronen for backing me! (y)

  3. Great article for TNWiki Article Spotlight and thanks for sharing it with community. Thanks for choosing new icon in signature 🙂

    1. Saeid Hasani says:

      Kamlesh, That was really a gorgeous and modest icon! I also liked the way you showed the cooperation around the Microsoft traditional logo! That was the best combination! Thanks again! 🙂

Skip to main content