Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from stackoverflow.com Jan 11 '13 at 13:28

This question came from our site for professional and enthusiast programmers.

2  
contact product support support.microsoft.com – Remus Rusanu Jan 11 '13 at 11:23
    
What does the SQL Server Log report? – Dave Jan 11 '13 at 13:03
    
What is SELECT @@VERSION? Have you run DBCC CHECKDB like the error message suggests? – Aaron Bertrand Jan 11 '13 at 16:18

If SELECT @@VERSION < 10.50.1746.0 then it is possible that the issue you are coming across has been fixed in a specific cumulative update, and can be averted by updating your instance.

The particular issue is described here:

KB #980832 : FIX: "A system assertion check has failed" error message...

The cumulative update is here:

Cumulative Update #4 for SQL Server 2008 R2 RTM

But I recommend applying the most recent service pack and cumulative update available (since they come with a slew of other fixes as well):

SQL Server 2008 R2 Service Pack 2

Cumulative Update #4 for SQL Server 2008 R2 Service Pack 2

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.