Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

I have 10 databases in my SQL Server 2008.

If I take a database backup, 8 databases are working just fine.

When I take database backup for the remaining two, at 50% of backup of process, the server automatically restarted. So I am not able to backup.

This is my production server. So please help to fix the bug.

share|improve this question

migrated from Jun 17 '11 at 7:32

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

You can start by looking into Server Log to see the possible reason. If server did not just "died" then it should have left some "comments". – LazyOne Jun 17 '11 at 7:42
On these 2 databases run the following and share the results. DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS – Sankar Reddy Jun 17 '11 at 17:50
  • Remove server from production, switch to backup. Smoething is VERY fishy on that server.
  • Do detailed server level analysis. This is NOT A SQL SERVER ISSUE - sql server only uses normal Windwos functions, not even installnig a kernel level driver. User level code can not issue a restart or crash the kernel, so something is wrong with the server.
share|improve this answer

Your Answer


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