Home → Problems →

[SQL Server] Database cannot be autostarted during server shutdown or startup

• Edit

mloskot

May 23, 2016 @ 03:09 PM

Hi,
I've been testing nanodbc library on AppVeyor against SQL Server 2014 without any issues.
So, I have added testing against against SQL Server 2008 and immediately, I've started observing a strange issue.
My tests are failing with infrastructure relate error:

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Database 4 cannot be autostarted
  during server shutdown or startup.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Problems recording information
  in the msdb..suspect_pages table were encountered. This error does not interfere with
  any activity except maintenance of the suspect_pages table.
  Check the error log for more information.

Most of solutions I found suggest it is database corruption issue, so some clean up queries with restart SQL Server is recommended, which, I guess, is useless on AppVeyor.

Here is my self-contained configuration https://github.com/lexicalunit/nanodbc/blob/master/appveyor.yml

Would anyone have a suggestion what might be the reason of this error on AppVeyor specifically?

1. Support Staff 1 Posted by Feodor Fitsner on May 25, 2016 @ 04:10 AM

   

   Is it that error reproducible when accessing with ODBC only? Have you tried using .NET or sqlcmd to access it?

   • Edit

2. 2 Posted by mloskot on Jul 14, 2016 @ 10:45 AM

   

   Fedor,

   The issue is gone. I have no idea what fixed it, but our builds (https://ci.appveyor.com/project/lexicalunit/nanodbc) are green against the three SQL Server versions available: 2008, 2014, 2016.

   So, I didn't have chance to try your suggestions, but I will in case the problem is back.

   Meanwhile, closing the thread.

   Thanks,
   Mateusz

   • Edit

3. mloskot closed this discussion on Jul 14, 2016 @ 10:45 AM.