Navicat Premium How to open SQL file. mdf and. ldf files

I'm sure you'll encounter a very headache when you reload SQL Server--after loading SQL Server, we find that the program is not started. Inexperienced will think that SQL Server installation failed to choose to reinstall, but hehe, re-installed 4, 5 times or the same, and then think of the reinstall system and so on.

In fact, we install the SQL Server process if the error is not reported, then the final installation will be successful. But there is no SQL Server launcher is the graphical interface to look at personal character, in fact, poor personality does not need to worry, because at this time also only need to install a graphical interface program is OK, you can choose Microsoft provides interface program MS SQL 2005 Express http://www.microsoft.com/downloads/details.aspx?familyid=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang= ZH-CN, but I still recommend Navicat Premium because this software not only supports SQL Server but also supports connection to MySQL, Oracle. After the installation, choose the corresponding connection method on the line, easy to solve the headache problem.

The next step is how to open the SQL Server file, provided you have to. MDF and. ldf two files. Assume that the path to the two files is E:/a.mdf,e:a_log. LDF, enter into NAVICAT Premium and connect SQL successfully, then click Query to create a new query input statement: EXEC sp_attach_db ' netking ', ' E:\A.mdf ', ' E:\A_log.ldf '. Where Netking is the name of the database to be established. The final reboot software will see the corresponding table appear in the database.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Navicat Premium How to open SQL file. mdf and. ldf files