Recover MSDB in SQL 2005

-
1.        Put MSSQL into single user mode
1.        Click -> START -> Microsoft SQL Server 2005 -> Configuration Tools – > SQL Server Configuration Manager

2.       Right click on SQL Server and choose Properties

3.       Click on the Advanced tab. Under Startup Parameters you will be adding the following parameters to the beginning of the string: -m;-c;-T3608

2.       Restart SQL Server
3.       Connect to SQL server through the Management Console. From this point on we will be using TSQL to issue the commands so click the New Query button on the top left. At this point you should be in the master database inside the query window.
4.       Detach the MSDB database using the following commands:
use master
go
sp_detach_db ‘msdb’
go
and click Execute



5.        We need to move (or rename, I prefer moving them) the existing MDF and LDF files for the MSDB database so that we can recreate it.
1.        Usually these files are located in the following directory:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DataYour’s might differ.
2.       Move (or rename) the MSDBDATA.mdf and MSDBLOG.ldf files.
6.       Back to the Management Studio. Open up the instmsdb.sql file in a new query window. This file is usually located in the following directory:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install
7.        Execute the file. If you see any errors about xp_cmdshell, just ignore them. They are common and the script will take care of it.
8.       At this point you should have your MSDB database restored. The only thing left is cleanup.
9.       Execute the following command to make sure that xp_cmdshell is once again set to disable for security reasons:
EXEC sp_configure ‘show advanced options’, 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure ‘xp_cmdshell’, 0
GO
RECONFIGURE WITH OVERRIDE
GO
10.     Shutdown SQL Server
11.      Go back into your Startup Paremeters for your server in the SQL Server Configuration Manager and removed the -c;-m;-T3608 parameters we added earlier.
12.     Restart SQL Server

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