Saturday, December 06, 2014

Duplicate Signature Remover (Sanchay Post)

Delete duplicate Signature Tool for Sanchay Post

  1. Unzip and copy a_signature.pbd , patch_signature.exe to /SP5/Comm folder.
  2. Execute patch_signature.exe.
  3. After selecting the scheme , this will list duplicate accounts in 1st datawindow, if exists.
  4. The selected account number along with seqno will be displayed in 2nd datawindow.
  5. By Clicking on this acctno, signature is displayed.
  6. When Delete Signature button is clicked a confirmation message is displayed and then the selected account is deleted from Sign database.


Recover MSDB SQL Database Corruption

Today i am gonna discuss here about the problem i have faced in many offices i.e. MSDB corruption. MSDB is very important system database as it stores backup maintenance plan, alert, operators, maintenance plans, backup history, Policy-Based Management settings, Database Mail, Performance Data Warehouse, etc. Obviously it is recommended to backup system databases as well. you can restore system databases easily by creating new system database and and then restoring from the backup (you can Google it). But I am gonna discuss here what if, you don't have any backup file. You can of course create new System databases but you will need to reconfigure you SQL Server in that case and you will have to attach all the databases and create jobs alerts etc (very time consuming process). So I am gonna discuss ans easy and less time consuming process. Here are the steps: -
Stop all the SQL Services and Applications.

Open CMD (command Promt) and type the following command : -

  • Now detach the MSDB (corrupted database) using this command : - 
"SQLCMD -E -S -dmaster -Q”EXEC sp_detach_db msdb”
  • Now browse the Microsoft SQL Server folder in program files-> MSSQL-> data (it will look like"C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA" you can check your own) Now move the msdb file to some other folder. (just in case you need backup)
  • Now start all the SQL Services.
  • Now in Command prompt enter this command -> 
"SQLCMD -E -S -i” C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Install\instmsdb.sql” -o” C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Install\instmsdb.out”
  • Open instmsdb.out file stored in 
"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Install\instmsdb.out"  using notepad and see if there is any error in the operation.
  • create maintenance Plans, alerts, jobs etc.
  • Don't forget to backup your system databases now. Happy Trouble-shooting!

SQL Data Base Recovery Tool for Post Office

DB Recovery Tool by Dinesh

A handy tool to recover your corrupt database using queries!

It helps you to recover you corrupt SQL database using queries mentioned in it. A backup is obviously preferred but if that doesn't work, this tool may help you! Click here to download it or click here for latest updates.
  • Click Config Button to configure your Server details and restart the application. 
  • Then select any of the Database listed below or check "None of Below DB" to enter database name manually. 
  • First Check the status of database clicking Status and Check Button (using DBCC Check Command). 
  • Then click Recover button to recover database. All the queries have been given in About form (Click About Link). 
  • Various database status has been explained under "?" button and for SQL proficient User advance mode has also given if none of the other options in tools recover the database. 
  • Write me back if you find it useful.

Download DB Recovery Tool


Developed by Dinesh Kumar Asotra, System Manager Una

Color Code for CAT 5 Cable Connect with RJ45 Connector

Color Code for CAT 5 Cable

The CAT-5 is a standard cable which has four twisted pairs of colors. It is easy to crimp a RJ45 connector to CAT-5 cable and make it into a straight cable or cross the cable as required. To make a straight cable, the ends must be crimped in the same way at each end. When making a crossover cable, some wires of certain colors have to be reversed.

CAT-5 cable is usually divided into 4 twisted pairs of colors:

Orange / orange-white
Green / green-white
Blue / white and blue
Brown / brown-white

Straight Cable Color Code

To make a straight cable, the tips must be crimped typically the same way attach end by respecting the twisted pair size.

In general, the color code used is:
1) orange-white
2) orange
3) green-white
4) Blue
5) blue-white
6) Green
7) brown-white
8) brown

Crossover Cable Color Code

For a crossover cable, swap 1 with 3, and 2 with 6, in the list above. This gives:
1) green-white
2) green
3) orange and white
4) Blue
5) blue-white
6) orange
7) brown-white
8) brown