SQL SERVER Unable to Attach Database File Activation Failure The Log Cannot be Rebuilt
Posted by: Journey to SQL Authority with Pinal Dave,
on 04 Nov 2016 |
View original | Bookmarked: 0 time(s)
Once I was in a situation where there was a disaster faced by my client. They lost the drive which was having transaction log file. Since they did not have effective monitoring, they realized that the backup jobs were failing. So essentially they only have MDF files for user databases and they were left with option to rebuild the log. Let us learn about how file activation failure can create an interesting error. First appeared on SQL SERVER – Unable to Attach Database – File Activation Failure –...