the database MSDB is marked suspect by recovery Error: 926 in SQL2005 server

I am getting the error in SQL 2005 server. Please help.
the database MSDB is marked suspect by recovery Error: 926
Joji JosephSenior Manager - Information TechnologyAsked:
Who is Participating?
 
sachinpatil10dCommented:
Try recreating MSDB database

1. Detach the msdb database to do this run Sqlserver as below
go to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\

start sqlservr.exe -c -T3608

2. Move the msdb files msdbdata.mdf and msdblog.ldf from C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to some other location

3. Run the instmsdb.sql script from C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install

4. restart sql server in normal mode.
0
 
sindhuxyzCommented:
1. Stop the SQL Server database & services

2. Rename or move the "msdblog.ldf" & "msdbdata.mdf" files

2. Copy "msdblog.ldf & msdbdata.mdf" files from any other working database installation to the same path

3. Start the SQL Server database
0
 
Anthony PerkinsCommented:
Do you not have backups?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.