Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : General : SQLServer

MSDB was suspected,error throws while taking backup

Microsoft SQL 2000

1.Stop the MS SqlServer
2. start the server with trace flag 3608 (for ex: C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr.exe -c -T3608 )
a)login to osql prompt
b)Execute sp_detach_db msdb
c)exit the osql prompt.

3. rename the damaged msdb files in
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf

4. Run the instmsdb.sql script in the 'C:\Program Files\Microsoft SQL Server\MSSQL\Install' directory
osql -Usa -i instmsdb.sql
5. after finishing of that script, please stop the sqlserver which was in trace flag and start normally

MSSQL 2005 /Default/GFT instance





OR






1.Stop the MS SqlServer or MSSQL$GFT
2. start the server with trace flag 3608 (for ex: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr.exe -sgft -c -T3608 )
a)login to osql prompt
b)Execute sp_detach_db msdb
c)exit the osql prompt.

3. rename the damaged msdb files in
C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\Data\msdbdata.mdf
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\msdblog.ldf

4. Run the instmsdb.sql script in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install' directory
osql -Usa -S . -gft -i instmsdb.sql
5. after finishing of that script, please stop the sqlserver which was in trace flag and start normally




Referance For MSSQL2000:
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx

Referance For MSSQL2005:
http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/



Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB