This error occurs while I restore database from .bak file
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. (Microsoft SQL Server, Error: 3624)
After this the Database goes offline and it property sets to Single User.
SELECT @@VERSION
? Have you runDBCC CHECKDB
like the error message suggests?