How to Repair Corrupted SQL Server Database Manually?

SQL  is stand for structure query language and SQL server is a database management system which is used to store and manage the data. If you are using Ms SQL database hence corruption is very common issue there. There are many reason of  corruption, errors and prevention in SQL database.

Cause of  corruption in a MS SQL Database

  • Power failure/improper system shutdown
  • Media corruption
  • Data storage failure where MDB files are stored
  • File header corruption
  • Hard disk failure
  • Storing SQL database in compressed folders
  • Computer virus/malware
  • Human errors
  • Modification in SQL account
  • Defective networking device
  • Upgrading to SQL server
  • Insufficient space


How to avoid MS SQL database from any virus or bug?

  1. Make use of WAF (web application firewall) to prevent database from any malicious infections.
  2. Delete unwanted functionality to prevent database from any computer hacker.
  3. Authenticate all the entered data
  4. Use static statements, queries or procedure
  5. Use limited access account
  6. Change your application password on regular bases to prevent data from hackers.

Here is the manual method to Repair of Ms SQL Database using Rebuild Wizard (Rebuildm.exe)

This is an vital method to repair the master database with the help of Rebuild Wizard. The given wizard is located in the following place:

\Program Files\Microsoft SQL Server\80\Tools\BINN directory.

Step 1: Launch  the Rebuild Master by double-clicks

Repair SQL Server Database Manually.

Step 2: A Rebuild Master tab open and here, you will see the Collation Settings and location of data files. Select the database file & verified all other information. And, then click on Rebuild.  

Note: Take a copy of the source directory from the SQL CD to your hard drive.

Step 3: Now, you will see the confirmation message. Click on Yes button and after the completion of process, you will receive a message about the rebuild was successful.  Now, you have a new master database and you can restore the master database easily.

Step 4: Now, start a SQL Server in SINGLE USER mode by opening up a command prompt and typing the command sqlservr.exe –c -m from the \Program Files\Microsoft SQL Server\MSSQL\BINN\ directory.

Step 5: From a backup, store the master database or you can also store it with the help of Query Analyzer or SQL Enterprise Manager.

Step 6: After restore, exit the SINGLE USER mode and restart SQL Server in NORMAL OPERATION mode.


  • If the restore operation failed then try an alternative method. First, rebuild the master database and attach all of your databases by using Enterprise Manager or Query Analyzer.

In Enterprise Manager, right-click on Databases and choose Attach Database.


If the above method did not help you to repair your SQL Database. You would suggest you to try the Free Trial version of Third party Application. Most of company offer Free trial version, Which allow you to repair your SQL database and Show you the Preview of Recover Data. One such application is here which you can try at Free of Cost. You need to pay only when you are completely satisfied with the software.

Download Now.        Munual Guide to Repair OST file



Tagged , , , , , , , , ,

How to Fix the Error “Unable to Expand the Folder” in MS Outlook?

MS Outlook creates a mailbox which holds all the attachments and emails in various folders. To store mailbox data there are two types of files used on your local drive – Offline Storage Table (OST) file and other is Personal Storage Table (PST) file. You should use OST file to configure Outlook in offline mode. In OST file, all the offline work is store and synced with Exchange Server when it is connected to the internet.

Sometimes, it shows the following synchronization error –


Unable to expand the folder. There are errors in xxxx.ost file. The folders couldn’t be opened. Quit all the mailbox applications and use Inbox Repair tool.


If you get this type of error, there must be a problem in your OST file and it couldn’t get synced properly with Exchange Server. Some of the common reasons of OST file corruption are –

  • Exchange Server crash
  • Virus attack in OST file
  • Exchange Server Database Corruption
  • Mailbox deleted from Exchange Server


How to Fix?

As discussed in the error message, quit all the applications which might be using OST file.

  • Retrieve the repaired items.
  • Repair OST file by running scanpst.exe (Inbox Repair Tool).
  • Find OST file


In some cases, Inbox Repair Tool doesn’t repair OST file because this tool is not sufficient in complex scenarios of corruption in OST file. If it is not working, it is better to use OST Recovery tool for OST to PST file conversion. These tools can convert the files even in severe cases of OST corruption and recover all the OST file components, such as emails, contacts, attachments, notes, tasks, calendar entries, etc. After getting converted PST file, it can be saved to any storage media or disk and open it with Outlook directly.


Good thing about this software is that, you can use Free trial version. Free trial version will show you all the recoverable emails in preview items, where you can check your desire emails. And allow you to save some emails in Free version.

FREE Download and TRY:   Munual Guide to Repair OST file

Tagged , , , , , , , , ,

Manual Guide to Repair Corrupt PST File with Inbox Repair Tool (scanpst.exe)?

When mail has become the important medium of communication for professionals, the population of Outlook users is growing in each passing day. Outlook is the most popular and widely-used email client as it manages your emails very effectively. All the Outlook files are stored in Personal Storage Table (PST) file, such as emails, contacts, schedules etc.


But the only problem is that PST file has the storage limit of 2GB. Oversized PST files may lead to different errors. The size of PST files increases day by day. Outlook also gets slower and it needs more resources to finish the tasks. Sometimes, it shows an error “Couldn’t start MS Office Outlook. Couldn’t open Outlook Window” when opening MS Outlook application. It may show error either because of oversized or corrupt PST file.


Microsoft provides an Inbox Repair Tool (scanpst.exe) to deal with these errors. It is your first aid and an inbuilt repair tool. It comes with Outlook for free to repair your corrupt PST file. Initially, it attempts to scan the corrupt PST file that is stored in the hard drive locally to verify its file structure.


How to Use Inbox Repair Tool (scanpst.exe)?

The tool also restores the file structure and rebuilds the header of the file if the structure is not intact. If you have 32-bit Windows, you can find scanpst.exe in Program Files. If you have 64-bit Windows, it is stored in Program Files (x86). Once the file is found, follow these steps to use this tool –

  • Before opening this Inbox Repair Tool, make sure the MS Outlook is Closed.
  • According to the Outlook and Windows version, look for the tool in default location and run scanpst.exe. You can also use Windows Search option if you cannot find the file at the default location.
  • Enter the PST file name that you want to repair or choose the file by Clicking “Browse” which lists all the files to be repaired.
  • To change the default process of creating new log file in scan process, to overwrite the existing file, or to create no log file, click on “Options”.
  • When you click “Start”, the tool will analyze the files and show the result.
  • If it shows error during the scan process, choose “Repair” and start the process. You can also change location and name of backup file which is created in this step.
  • Open Outlook application which consists of PST file that is repaired.
  • In Folder tab, go to Folder list view.


The “Recovered Personal Folder” in Folder pane consists of default mails. On the other side, the “Lost & Found Folder” consists of recovered mailbox files. In your profile, you need to create new PST file in the “Lost & Found Folder”.


What to Do If Inbox Repair Tool Doesn’t Work?

If Inbox Repair Tool doesn’t work at all, you can use the professional Outlook PST Repair tool. It is a complete repair solution that can restore all the damaged PST data without harming its original formatting. It can perform scanning and proper repair to access all the emails, contacts, attachments, calendars, journals, and responsibilities. You can easily view the repaired items after restoring PST file.

We recommend our user to use Free trial version, Free version will help you to take a decision, is it Good for you or Not. Free Trial Version will show you the Preview of recovered data before saving. Download Now. 

Tagged , , , , , , , , , , , , , , , , , , ,

How to Fix “Runtime Error” in Microsoft Word?

In Microsoft Office suite, Microsoft Word is a default word processing tool. It is a word processor which provides a lot of helpful functions to the user that is built from the sets of Visual Basic commands. It enables users to write, edit and remove any text without using a lot of technical knowledge in its functioning. It is known to be the prominent reason behind its popularity.


Due to a runtime error, a program cannot work as expected. It can happen because of any reason, such as errors, loss of data, corruption in the file and features which are not functioning. Hardware or software problems are other common issues. They don’t make Windows to stop functioning and they don’t cause any other problem.


Basically, runtime error indicates that a WLL or DOT file is corrupt in MS World. Such types of files are stored in Startup folder of the program. You can use Word with troubleshooting mode in that case.

  • Click on Start menu and open Run dialog box.
  • Type in “winword/a” command. With this command, Microsoft Word will open in troubleshooting mode.
  • Click OK to open MS Word


Once MS Word is open, next step is to find out whether the issue is caused due to global templates or third-party add-ins. In order to start the process, simply –

  • In “Tools” menu, choose the option “Templates & Add-Ins”.
  • Click on entry to inspect its actual location (basically, it must be in Office Startup folder).
  • Click on “File” menu and click “Exit” option to exit Microsoft Word.
  • Go through the location of the add-in or template and go to Startup folder. Move the entries off the folder for several entries at the time to figure out which module caused the error.
  • Start MS Word normally to find out if it is fixed.


If you cannot find the Startup folder for MS Word, just launch MS word in troubleshoot mode and –

  • Click on “Tools” menu and choose “Options” category.
  • On “File Locations” tab, choose “Startup” folder
  • On “Modify” button, pick your preferred location.
  • Save options and exit MS Office.


As MS Word Runtime Errors are attributed to the template files, there are two different ways to fix the issue –

  • Find out the Normal.DOT file and rename the extension (be sure that the extension is modified, not the file name).
  • Another option is to delete Normal.DOT file completely.
  • Launch MS Word normally. Since global template file is absent, create another MS Word file with its default settings.
  • If this issue is still not fixed with these options, it is better to remove MS Word with Add/Remove Programs, in Control Panel.
  • Restart the system and install MS Word again.


Make sure all the programs with its applications like Outlook, plugins and Internet Explorer are closed before you rename or remove the Normal.DOT file.


Using Word Repair Software

The methods discussed above are based on trial and error to fix the issue. For more accurate and better results, use Word File Repair Software to repair corrupt .docx and .doc files. It is developed with advanced functionality to repair infected or corrupt MS Word files from all the major and minor file corruption.

Use Free Version to See Preview of Recoverable data:   images

Tagged , , , , , , ,

Know the Reasons Behind Corruption in External Hard Drive

Your hard drive is supposed to be a very important part of your system. This hardware caters to several storage needs on your system. According to the storage space and computer itself, several types of hard drives are available. But a hard drive is vulnerable to crash anytime, leading to some serious issues. Due to these crashes, an external hard drive may corrupt and result in inaccessibility of your data.  But there are ways to recover the data from your damaged external hard drive.


Operating system crash is another important reason behind the inaccessibility of data. But it is the way too different from hard drive failure. Operating system crashes because of logical failures. On the other side, hard drive crashes because of physical failure. Sometimes you cannot access your data when it is actually stored on hard disk. In that case, it is very vital to recover files from your hard drive.


To find out whether the failure is physical or logical, you have to analyze the error messages and symptoms. For instance, if your system is making grinding or clicking noise and not booting, the crash may occur because of some physical issues. We have pointed out some of the common reasons of external hard drive failure.



Due to the continuous use of your system, the temperature of your hard drive may be soaring high. Overheating is the most common problem caused by inferior quality of cabinet and faulty CPU fans. The fan doesn’t move or moves slowly if it is faulty. It causes unexpected sound of clicking from the system.


Manufacturing Defects:

Some external hard drives are faulty since the time of manufacturing. These hard drives may work abnormally and don’t function at all, after a few days of buying. It happens more often because of improper analyzing and testing on manufacturing process. Due to manufacturing defects, hard drive may become inaccessible and often result in boot failure.


Unexpected System Turn off:

Due to unexpected power cut, system may turn off abnormally if you don’t have UPS. Along with it, fluctuation in power supply and voltage can also lead to serious damage to your hard disk. So, it can be undetectable from the BIOS.


Mechanical Issue:

An external hard drive is manufactured with several mechanical parts. Failure in any mechanical part can lead to abnormal behavior of hard drive. You might face a problem in rotation of spindle motors or clicking sound because of bad sectors.


Data Corruption:

Data is likely to corrupt because of several reasons, such as unexpected system shutdown, virus attacks, power failures etc. Hence, you cannot access any folder or file in your PC.


Drive is Not Recognized:

A computer may not recognize hard drive if it is failed. You cannot boot the system with undetected hard drive, especially if it is primary bootable device. Along with it, you cannot also see the drive letter in the list when looking for the drive.


Inaccessible Data:

It happens more often when hard drive is failed. The file s stored on the system may go inaccessible. In that case, an icon might be seen on the file but you cannot access it.


Folder/Files Don’t Open Quickly:

If it takes more time to open your folders or files than usual, it is the sign of hard drive failure. Due to this extended time to access the folder or file, it might show “Blue Screen of Death”. Slow booting process is another symptom of hard drive failure.


Unwanted Noises:

Unwanted noise from your hard drive also indicates the mechanical failure in the hard drive. It happens when the head of hard drive touches platter. This type of noise indicates that the drive is failing while booting the machine.


Bad Sectors:

If Windows detects any bad sectors present on your hard drive, it’s time to backup your data quickly and replace your hard drive. Windows comes with an integrated tool to check error to scan the drive.


Human Errors:

Any type of mishandling can lead to corruption in hard drive. Basically, mishandling is possible due to any actions like altering the system file and modifying registry files. These activities can make hard drive failed. There are several signs to cause failure in hard drive. These signs can help you against any unexpected data loss by taking proper actions before loss.


Unknown Errors:

There are certain unknown errors that can make your hard drive inaccessible. Some of the errors are –

“H:\ is inaccessible”

“Hard drive is inaccessible. Format it first”

“Type of file system is RAW”


Fixing all of these errors is not possible. But you can, at least, conduct background check and figure out the root cause. This way, you can opt for the relevant solution.


Other Signs

Along with the above possible signs, you also have to look for other possible signs of failure in hard drive. Such as –

  • Incorrect appearance of folder names and file
  • Hard drive crashes every time when booting the Windows
  • Error messages while doing any important activity or moving files
  • Folders and files getting missed
  • Incorrect properties are shown in hard drive, such as available space
  • Showing file results in distorted format


How to Recover Data from Corrupt Hard Drive?

If the external hard drive is corrupt, it doesn’t mean your data is lost forever. Instead, you can recover your data from corrupt hard drive. Be sure that the drive is not used after these incidents. If you keep using the damaged hard drive, it will make things worse and you may not recover the data successfully.


This Hard Drive Data Recovery Software is capable to recover your data from these situations and it can detect these drives to provide data recovery. This tool can easily recover the whole data from inaccessible or damaged hard drive and other media. You may try it before buying. Download Free Trial Version of this program and install on your system. It can show you the issues in its software interface and provide options to recover data. You can see your recoverable data in Free Trial version.

FREE to Try NOW :  

Tagged , , , , , , , ,

Manual Guide to Repair Corrupt OST File Through Free Integrated Scanost.exe Tool

Microsoft Outlook is one of the most widely used email clients as it comes with a lot of exciting features. MS Outlook stores the email files and information in Personal Storage Table (PST) and Offline Storage Table (OST) files. As the name suggests, Offline Storage Table is the format which enables users to work in offline mode when Outlook is not connected to Exchange Server.

All the offline data is stored and created in OST format when working without connection with Exchange Server. The best part of Outlook is that it enables users to modify the content offline and save changes in OST file, which is synced once it is connected to the server.

Sometimes, users cannot connect to Exchange server when using Outlook due to various errors that are unidentified and unknown. There are several reasons responsible for this failure, such as hard drive failure, unexpected system shutdown, virus attack etc. which damage OST file. Once this file is corrupt or damaged, you cannot access it and sync with Exchange server properly. In that case, you should use scanost.exe which is an Integrity Check Tool that comes with Outlook for free.


By default, this tool is located at C:\Program Files\Microsoft Office\Office_version. It performs integrity check of OST file. The best thing is that this tool doesn’t alter the hierarchy of mailbox. All it does is scanning the corrupt OST mailbox and attempts to fix the synchronization problems in OST file. It recreates the header of data file and resets the structure of the file to repair offline data. Make sure Outlook is connected to the server to start this tool. Here’s how to use this tool –

  • Close MS Outlook if it is open.
  • Browse scanost.exe at C:\Program Files\Microsoft Office\Office_version
  • Open scanost.exe
  • It will prompt you to choose a profile as per your setting in MS Outlook. Choose a profile which consists of corrupt file.
  • It has two options “Work Offline” and “Connect”. You have to click “Connect”.
  • Choose the “Repair Error” checkbox to repair the error with this tool. It will create a scan log without repairing it if you don’t select this box.
  • Click “Start Scan”
  • Open MS Outlook to view the scan log. In “Deleted Items” folder, click “OST Integrity check”.


What If Scanost.exe Doesn’t Work?

The Deleted Items folder also contains the items that cannot be repaired by this tool. If the error cannot be fixed with this tool, it is better to download OST to PST Converter software. It is a simple and easy to use OST to PST Converter that comes with exciting features along with OST to PST conversion. With few clicks, you can convert corrupt OST files into PST files and other formats like Office 365, MSG, EML, PDF, and HTML. You may download free trial version which allows conversion of 20 items in each folder from OST to PST files. You can easily convert all the mailbox items, such as emails, contacts etc. without any error.


Tagged , , , , , , ,

How to Fix “Cannot be Accessed” Error in MS Excel?

Microsoft Excel is the most effective and popular tool to present and analyze data. It is used by both professionals and home users. Sometimes, it is often hard to find out the data it shows to generate usable information on regular basis. These days, users encounter several issues in Excel file. To deal with the common error “.xls cannot be opened”, users have designed their own methods, such as –

  • Backup the files and having multiple copies
  • Saving the files in other formats like .csv etc.
  • Paste data as values if you don’t need the formula
  • Hoping that the file will open well next time


There are different causes of Excel File corruption and why it goes inaccessible –

  • Unstable Macros – Macros may have several lines of code and they were used in data processing. They are basically error-free. But they may cause errors at some point. Excel calculates all the formulas after opening the file and before closing it. Any resource operation may crash the application or freeze it at any time.
  • Virus Attacks – If a file is attacked by malware, there are chances that antivirus may make it inaccessible due to cleaning and restoration jobs.
  • Dirty Shutdown – Excel automatically saves the file in a temporary form in case it is closed unexpectedly. Sometimes, the temporary version of the file cannot be restored.
  • Multiple Network Locations Used to Access the File – Accessing Excel File from several locations may disable editing from other file. If you are logged in from other computer on one network, you may not be able to edit the file.
  • File is opened in Another Computer – When you involve a network location, several permissions may be required. Even in case the file is saved and closed, it may show that the file is currently being used.


Tips to Prevent this Issue:

The methods discussed above are not the actual solutions per se. However, they are actually the idea on what you can expect. Here’s how to avoid these situations –

  • Don’t access the file from several network locations. If it is important, create a local copy to make changes, save changes on the system, and close the file. Copy the file and paste it to the desired location to overwrite it.
  • Make copies of the file and split the larger file whenever possible, month-wise or week-wise, whenever it gets larger in size.
  • If it is in .xls format and the current version is Excel 2007, convert the file (Office menu – Convert) to cut the file size.
  • If the file is read only or corrupt, save the file in XML format. Reopen the Excel file to convert the same.
  • Recheck the macro or formula and replace the resource formula with lighter variant.


How to Fix Them?

If your Excel file is inaccessible or corrupt, you should try the Free Trial version of Excel File Repair software. It is a professional tool to repair MS Excel files and restore all the references, formulas, charts, references etc. It is a handy tool that can repair .xls and .xlsx files while keeping the formatting, sheets, macros, and cell commands unaffected.

Free Trial Version will show you the Preview of recovered data before saving. Download Now. 




Tagged , , , , ,