How does Navicat Premium open the SQL file. MDF and. LDF, navicat. ldf

How does Navicat Premium open the SQL file. MDF and. LDF, navicat. ldf

I believe you will encounter a very headache when installing SQL Server again-after installing SQL server, you will find that the program has not been started. If you have no experience, you may think that the installation of SQL SERVER fails, So you choose to reinstall it. However, if you reinstall it for 4 or 5 times, you still need to reinstall the system.

In fact, if no error is reported during SQL SERVER installation, the installation will be successful. However, there is no SQL SERVER startup program, that is, the graphical interface, which depends on the personal character. In fact, poor characters do not need to be worried, because at this time, you only need to install an additional graphic interface program, you can choose the Microsoft interface program ms SQL 2005 Expresshttp: // www.microsoft.com/downloads/details.aspx? Familyid = c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796 & displaylang = zh-cn, but I still recommend Navicat Premium because it not only supports SQL SERVER but also MYSQL, Oracle. After the installation, select the corresponding connection method, which easily solves this headache.

The next step is how to open the SQL SERVER File, provided that there must be two files:. MDF and. LDF. Assume that the path of the two files is E:/. MDF, E: A_log.LDF, enter Navicat Premium, and connect to the SQL statement. Then click query to create A new query. Input statement: exec sp_attach_db 'netking', 'e: \. mdf ', 'e: \ a_log.ldf '. Here, netking is the name of the database to be created. After the software is restarted, the corresponding table appears in the database.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.