Skip to main content
3 of 6
Update re: restore script availability
EngineeringSQL
  • 579
  • 2
  • 7
  • 16

SSMS Database Node Refresh causes Restore to Fail

I have confirmed via testing that clicking on the refresh icon (one or more times) for the database node of a SQL Server instance being observed in SQL Server Management Studio (SSMS 2012) causes my 3rd-party database restore software to fail. If the refresh icon is not clicked, then the restore succeeds.

My question: what occurs in the SQL Server engine (or the msdb database) when the refresh icon is clicked?

Update (2:36pm) When the failure occurs, one database is left in a restoring state. The specific error is "The database cannot be recovered because the log was not restored."

Update (2:48pm) The 3rd-party database restore software is GUI-driven. A restore script is not available to post. I will capture the commands via Profiler.

EngineeringSQL
  • 579
  • 2
  • 7
  • 16