Shulou(Shulou.com)05/31 Report--

This article will explain in detail how sql server 2008 uses mdf and ldf files to restore the database. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Method 1:

1. Copy the mdf file and ldf file to the default path C:\ Program Files\ Microsoft SQL Server\ MSSQL10.MSSQLSERVER\ MSSQL\ DATA in the database; this path should be arbitrary. You can try it.

2. Create a new query in sqlserver and execute the following code

USE master;GOCREATE DATABASE NewFile ON (FILENAME ='C:\ Program Files\ Microsoft SQL Server\ MSSQL10.MSSQLSERVER\ MSSQL\ DATA\ File.mdf'), (FILENAME ='C:\ Program Files\ Microsoft SQL Server\ MSSQL10.MSSQLSERVER\ MSSQL\ DATA\ File_log.ldf') FOR ATTACH;GO

3. Refresh the database, and a new database NewFile appears.

Restore successfully according to mdf file and ldf file!

Method 2:

Open your SQLSERVER2012 Enterprise Manager, database-- all tasks-- attach database

On "sql server 2008 how to use mdf and ldf files to restore the database" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.