Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 me.how to fix the bug.

share|improve this question

migrated from stackoverflow.com 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
add comment

1 Answer

  • 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
add comment

Your Answer

 
discard

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