Msdb Corrupted/Suspected Solution SQL2000/2005

-

Msdb Corrupted/Suspected Solution SQL2000/2005



Msdb Database Suspected/Corrupted-Solution (SQL 2000&2005)


In Sql server 2000, you start the server with trace flag 3608.

In SQL Server 
Enterprise Manager, right-click the server name, and then click Properties.
On the General tab, click Startup Parameters.
Add the following new parameter:
-c -m -T3608
After this restart the sql server and detatch the msdb database and move the mdf and ldf files from the default folder C:\Program Files\Microsoft SQL Server\MSSQL\DAta
Then recreate msdb file by executing in new query window
instmsdb.sql (C:\Program Files\Microsoft SQL erver\MSSQL\Install)
Then remove-c -m -T3608 from the startup parameters in SQL Server Enterprise Manager
Then stop and restart the sql server 2000 and then recreate the maintenance plans


In SQL Server 2005
Detach the msdb database and install/create new msdb database. This will solve the problem. But the problem is that SQL Server 2005 does not allow to detach a system database. This will be solved by the following
another way is (you start the server with trace flag 3608. )
Start>Sql Server 2005>Configuration Tools>SQL Server Configuration Manager

Then click on SQL server 2005 services.
On the right side>Right click on SQL Server>Select Properties
Click on the Advance Tab and change the Parameters of Start up Parameters 
ie please add -m;-c;-T3608 in front of the existing parameter.
Then restart SQL server
detach the msdb database by query
use master
go
sp_detach_db ‘msdb’
go
and click Execute

Then move the existing mdf and ldf files of msdb fromC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data 

 Then recreate msdb files open the nstmsdb.sql(C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install) in a new query window and execute, Then your msdb is restored. 

Before restarting the sql server remove the parameters (-m;-c;-T3608 )Then restart the sql server. Be and recreate the new maintenance plan.

Comments

Post a Comment

Popular posts from this blog

Applet Not initialized properly’ Error in Finacle – Solution

-
Image
Some time , even after installing all java updates and configurations we face issue of  "Applet Not initialized properly’ Error in Finacle"           the best solution for the same is 1..  Use java 7 updt 17 (It always works fine) - if any other version is installed , kindly uninstall the same 2.  now  navigate to following path C:\Users\Administrator\AppData\LocalLow Delete the folder named SUN. Now clear cache and history of internet explorer and re launch internet explorer.  Give a tick in check box and click Later Give a tick and click RUN Here also give a tick and click on RUN Sometimes if you response was delayed it will show Error loading applet. But no problem. Just give user id and password and login. Now when you select FINCORE, another pop up will come as shown below Here also, give a tick in the check box and click RUN.          ...
Read more

Create an HTML document giving details of your name, age, telephone number, address, TLC code & enrolment number aligned in proper order.

-
Create an HTML document giving details of your name, age, telephone number, address, TLC code & enrolment number aligned in proper order. <html> <body> <ol> <li>Name : Ketan D Joshi/li&gt; <li>Address : At &amp; Po Gadh</li> <li>Mo NO- +91 0000000000</li> <li>Desi.: Student at IGNOU Nootan Bharati Madana</li> <li>En. No: 145566778</li> </li> </ol> </body> </html> Out put Hope you all will enjoy this Post. Any kind of positive suggestions regarding this post are heartly accepted. If any one has problem with this post content, kindly let me know through email , i will update or remove this post as soon as possible Thanks Regards Ketan Joshi SA Palanpur HO Mo no:+91 8866984506 eMail : k9724675876@gmail.com
Read more

Fresh installation of CSI Applications and Database

-
Image
After CSI Roll out, we often need to reinstall CSI Applications or create fresh database when existing server goes out of order like HDD Crash issues. By following the below steps, a fresh database and applcaitons can be installed easily in a new / formatted PC Copy Roll_out_2 folder into C:\POS_Installer Now Click on C:\POS_installer\Roll_out_2\POS\Others\Roll out\start.bat Click on get Started Button Enter Facility  ID of Office Click on Save button Download Download :             Source :            C:\Roll_out_2\POS\Software             Destination :    C:\POS_Installer           Click on Download button Application Source :            C:\Roll_out_2\POS\Application                Destination :    C:\POS_Installer         ...
Read more