Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

MS SQL Server crashed. Need in recovery.

sql server

Best Answer KennethHancock, 11 May 2015 - 08:02 AM

You can take the following actions:

First of all make a backup copy of this base. I had this problem too and helped me the following:

Turn off SQL, delete the log, turn on SQL, then:

1. 
use master 
go 
sp_configure 'allow updates', 1 
reconfigure with override 
go 

2. 
upd ate sysdatabases set status=32768 where name = 'msdb' 
go 

3. 
DBCC REBUILD_LOG('msdb', 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data\msdb.ldf') 
go 

4. 
use msdb 
go 
alt er database msdb se t SINGLE_USER with rollback immediate 
go 
use msdb 
go 
DBCC CHECKDB('msdb', REPAIR_REBUILD) 
go 

5. 
use master 
go 
sp_dboption 'msdb', 'single user', 'false' 
go 


6. 
use master 
go 
sp_configure 'allow updates', 0 
reconfigure with override 
go

Go to the full post


This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1 baldwin

baldwin

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 08 May 2015 - 01:35 AM

My SQL 2000 SP4 base was damaged after raid crash. Now it is marked Suspend. The backup is also not done unfortunately. And now it is possible to restore base?



#2 KennethHancock

KennethHancock

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 11 May 2015 - 08:02 AM   Best Answer

You can take the following actions:

First of all make a backup copy of this base. I had this problem too and helped me the following:

Turn off SQL, delete the log, turn on SQL, then:

1. 
use master 
go 
sp_configure 'allow updates', 1 
reconfigure with override 
go 

2. 
upd ate sysdatabases set status=32768 where name = 'msdb' 
go 

3. 
DBCC REBUILD_LOG('msdb', 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data\msdb.ldf') 
go 

4. 
use msdb 
go 
alt er database msdb se t SINGLE_USER with rollback immediate 
go 
use msdb 
go 
DBCC CHECKDB('msdb', REPAIR_REBUILD) 
go 

5. 
use master 
go 
sp_dboption 'msdb', 'single user', 'false' 
go 


6. 
use master 
go 
sp_configure 'allow updates', 0 
reconfigure with override 
go


Edited by WingedPanther73, 12 May 2015 - 02:32 PM.
Remove spammy link