Please navigate to Company Setup menu as shown in below image.

This module store company’s complete details including addresses and contact details.
How to add a new company?
On clicking on Company Setup, the module will be opened in display mode. You will see Company Navigation, Specific, Edit and Exit button.
Just press Exit button, on clicking Exit button, you will see Add, View/Edit and Exit.
Here Clicking Add button, a blank form will be opened as shown in below image and feed necessary data.

General Details
*Database:    This field saves the database name. The database name should not contain embedded space and special characters and should start with an alphabet.
Category:      You can Select Business Category here.
*Year:         You can select Financial Year here.
*Start Date:   This field mentions the beginning date of the financial period for the Company.
*End Date:     This field mentions the ending date of the financial period for the Company.
Firm Code:     You can Manage Firm Code here.
*Firm Name: This field saves the Company Name
Address:       This field saves the Company Address.
City:          This field saves City.
Pin Code:      This field stores Pin Code of the Company.
District:      This field saves District of the Company.
State:         This field saves State of the Company.
Country:       This field saves Country of the Company.
Fax No.:       This field stores Fax No. of the Company.
Telephone:     This field stores Telephone no. of the Company.
Mobile:        This field stores Mobile No. of the Company.
E-mail:        This field saves Email address of the Company.
Web-Site:      This field saves Web-Side address of the Company.
Holiday:       This field saves Holiday of the Company.
Currency:      This field saves Currency of the India.
Firm Type:     This field saves Firm Type of the Company.
Signatory:     This field saves Signatory.
*marked fields are compulsory.

On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look.

You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly.

To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template.

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Toggle Content goes here

Database files are important for all users and store lots of important information. Learn about manual and professional solutions to repair corrupt SQL database files.

Today’s MS SQL Server is one of the most popularly used relational databases. It has advanced internal structure and offers great reliability. That is why most organizations use the SQL Server database to save all crucial business data. But there are some situations, like virus infection, operating system failure, corrupt file system, etc., due to which SQL database becomes corrupt and all data stored in it is inaccessible. Repairing .mdf files from the corrupted state in SQL Server is not an easy task.

A user can use the manual technique to repair corrupted MDF file in SQL database but this is not a reliable approach because there is no guarantee of data recovery using manual approach. However, there are also third-party tools like SysTools SQL Recovery that claim to repair .mdf file in a perfect way.

Therefore, in this post, we are going to discuss best possible solutions to repair a corrupt SQL database. But before that, it is important to understand the reasons behind corruption in SQL databases.

Reasons Behind Corrupt SQL Databases

There can be various possible reasons behind corruption in a SQL Server database. As everybody knows, the MDF files of a SQL database are the primary database files. They store all user data, so corruption in MDF files can corrupt the entire database. Hence, first, we will discuss all possible reasons behind MDF file corruption:

  • Corruption in storage media where all MDF files are stored.
  • If a user has stored the SQL database in a compressed folder, then there is a chance that the MDF file will become corrupted.
  • Any modification or changes are done in a SQL Server account.
  • A user may have deleted some data accidentally.
  • If the file header is corrupted, then it results in corruption in MDF file.
  • Defected disk drivers.
  • If SQL database is in use and in between there is a network failure, it leads to corruption in MDF file.
  • Other possible reasons that cause MDF file corruption are virus attacks, hard disk failure, abnormal system shutdown, and abrupt power failure.

Thus, if the MDF file becomes corrupted, then the SQL database becomes inaccessible. Moreover, if a user tries to access the corrupt database, it may encounter some error messages. The most commonly encountered error messages are listed below:

  • Corruption in storage media where all MDF files are stored.
  • If a user has stored the SQL database in a compressed folder, then there is a chance that the MDF file will become corrupted.
  • Metadata corruption error.
  • A user may have deleted some data accidentally.
  • Msg 823 error in SQL Server/Msg 824 in SQL Server/Msg 825 (read retry) in SQL Server.

Apart from all this, there are some other error messages that a user may encounter while accessing a corrupt SQL database. Therefore, it is the responsibility of the database administrator to do something immediately and prevent any type of data loss.

How to Repair MDF Files Via Manually

There are several manual methods available to repair a corrupt SQL database but manual solutions do not guarantee database recovery.

In order to restore the corrupt database, a user can use NDF files (log files) of SQL Server. But only log files are not sufficient to restore the database in most corruption cases because sometimes, with major corruption, backup files also become corrupted.

Another possible way to repair and restore the corrupt SQL database is with the help of database console command i.e. DBCC CHECKDB. It is really helpful in fixing minor corruption issues in a SQL Server database.

Steps to Repair Corrupted MDF File With DBCC CHECKDB

First of all, you need to run DBCC CHECKDB on the corrupt SQL database by executing the following query:

DBCC CHECKDB (Name_of _corrupt _database)

Note: You can also define some options like no_infomsgs and infomsgs with DBCC CHECKDB.

After that, you need to check the index ID.

  • Case 1: If index ID > 1, drop it and create it again.
  • Case 2: If index ID is either 0 or 1, then run DBCC CHECKDB again with the appropriate repair options like repair_rebuildrepair_fast, or repair_allow_data_loss.
DBCC CHECK (name_of_corrupt_database, repair_fast)
DBCC CHECK (name_of_corrupt_database, repair_rebuild)
DBCC CHECK (name_of_corrupt_database, repair_allow_data_loss)

Now, to ensure zero corruption, execute DBCC CHECKDB and a message is displayed i.e. DBCC CHECKDB displays 0 allocation errors and 0 consistency errors in name_of_your_corrupt_database.

What If the Manual Method Fails?

Manual solutions are not always a foolproof solution. They may have some limitations. For example, in the case of severely corrupted MDF file, manual fails very easily. Moreover, a manual solution requires a user to be technically strong. Therefore, it is advised to use some authentic third-party software to repair corrupt SQL database. SQL Database Recovery Program is one of the best utilities to fix any type of corruption issues in MDF files.

SQL Recovery Tool is capable to repair corrupt SQL database files — both MDF and NDF. It is a risk-free software and recovers all data items stored in it like tables, rules, triggers, functions, etc. Apart from all this, the software will repair the database in just a few clicks without wasting any time.

Steps to Repair Damaged SQL Database From MDF File

Download and run SQL Recovery Program on your local machine.

SysTools SQL Recovery Tool

After that, open the corrupt SQL database file (.mdf file) of your choice.

slect Corrupt MDF file

Choose the Scan Mode and click OK.

Scan mode

The tool will provide a preview of data items stored in corrupt the MDF file.

view MDF file

Click on Export to save the recovered database.

Export MDF database

Conclusion

Database files are really important for any users, as they store lots of important information. Any type of corruption issue in SQL database can create trouble for users. Therefore, to overcome all these issues, we have discussed both manual and professional solutions to repair corrupt SQL database files.