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