March 28, 2011 at 2:18 am
Hi Team,
MSDB Database goes to suspect mode it gives below error.:
database msdb can't be opened it has been marked suspect
alterdatabase msdb set emergency mode
it is also giving same below error :
Option 'EMERGENCY' cannot be set in database 'msdb'.
March 28, 2011 at 2:31 am
Wow, was it really necessary to use that font size? Please edit and reduce that font to something readable.
Restore from your last good backup of MSDB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 28, 2011 at 3:00 am
Hi Gail,
SOrry my font. size 7 i dont know
the datapath is available in below path
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
using restore comman only i have to restore right
suggest any boyd properway..
this development box please help me as soon as possible.
Tx
March 28, 2011 at 3:04 am
Don't understand what you're asking.
Get your backup of MSDB and restore it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 28, 2011 at 3:26 am
Hi Gail,
RESTORE DATABASE MSDB
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\NewData\msdbdata.mdf'
WITH FILE=1,
NORECOVERY;
Msg 3241, Level 16, State 0, Line 1
The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\NewData\msdbdata.mdf' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
can you correct me..
March 28, 2011 at 3:37 am
Um, you restore from a database backup, not from the database itself.
You do have backups, don't you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 28, 2011 at 4:00 am
Hi Gail,
I dont have backup what should i do suggest me please help
March 28, 2011 at 4:08 am
Then you are going to have to rebuild msdb and lose any jobs, any DTS or SSIS packages, any backup history.
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx
Is there a DBA there who can help you?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 28, 2011 at 6:38 am
Hi Team,
I have follow below steps
Detach the damaged msdb. You can't just detach msdb because you're not allowed to detach system databases. However, you can if you start the server with trace flag 3608. I did this by shutting down the server, navigating to the directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn' and doing the following: start sqlservr.exe -c -T3608
Move or rename the damaged msdb files (msdbdata.mdf and msdblog.ldf in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' directory)
Run the instmsdb.sql script in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install' directory
Shutdown and restart the server without the 3608 trace flag
after that i got below error. can you please guide me..
----------------------------------
Starting execution of INSTMSDB.SQL
----------------------------------
Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.
How to run Reconfigure statement...
please help me on this...
Tx
March 28, 2011 at 6:44 am
That's not an error. It's just part of the output of the script, which probably had a reconfigure in it right after that.
Did the script complete successfully? If not, look for messages in red, probably starting with Error:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 28, 2011 at 11:29 am
in errorlog it shows below error
Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well
can you please suggest ...
March 28, 2011 at 11:43 am
No, because you are giving me no where near enough information.
Did the script run successfully?
Did you restart SQL afterwards?
Is MSDB online?
Can you query it?
If not exactly what errors does it return?
Exactly what messages are there relating to msdb in the error log? (all of them)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 28, 2011 at 11:56 am
Hi Gail,
I have given Error log information could you please check and update in the post entire day i am working in this but still im facing prob
in my orgnization no L3 plz guide me.
ADvance thanks give exact solution.
Tx
March 28, 2011 at 12:13 pm
Answer my questions. All of them.
I cannot see your screen, I cannot read your mind. I cannot help you if I don't know what you've done or what exactly the situation is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 29, 2011 at 7:37 am
We CAN help you but you need to tell us what you did and what error messages you have. Follow exactly what Gail says and tell us what output and/or errors you get following her tasks.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply