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

I'm sure you'll get a headache when you reload SQL Server--after you've loaded SQL Server, you're not starting a program. Inexperienced will assume that the SQL Server installation failed and then choose Reload. But hehe, re-installed 4, 5 times or the same. So I thought of the reloading system and so on.

As a matter of fact, when we re-install SQL Server, we assume that the error is not reported, then it will be installed successfully. But there is no SQL Server launcher is the graphical interface to look at personal character, in fact, poor character does not need to worry, because at this time also only need to install a graphical interface program is OK, 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 supports not only SQL Server but also the connection to MySQL, Oracle. After the installation, choose the appropriate connection method. It's easy to conquer this headache problem.

The next step is how to open the SQL Server file, if necessary. MDF and. ldf two files.

If the path to the two files is E:/a.mdf,e:a_log. LDF. Enter into Navicat premium and connect to SQL successfully, then click Query to create a new query input statement: EXEC sp_attach_db ' netking ', ' E:\A.mdf ', ' E:\A_log.ldf '. Among the netking is the name of the database to be established. Finally restart the software and you will see the corresponding table appears in the database now.

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