恢复ldf和mdf文件 [英] restore of ldf and mdf files

问题描述

hi


我有一个ldf和mdf文件，我想将它恢复到sql server。你能不能告诉我这个程序..



提前谢谢

hi
i have one ldf and mdf file and i want to restore it into sql server. could you please tell me the procedure..

Thank you in advance

推荐答案

这些链接解释了附加数据库。

如何在SQL Server 2005中附加数据库 [ ^ ]

附加数据库 [ ^ ]

These links explain how to attach a database.
How to Attach a Database in SQL Server 2005[^]
Attach a Database[^]

将ldf和mdf文件复制并粘贴到[C：\Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \Data \]（这可能是你有不同的路径。）



数据文件夹启动查询分析器后单击对象资源管理器和r点击数据库，你会得到附加选项点击附加后，

你会得到一个窗口作为附加数据库，然后点击添加按钮从数据文件夹中选择你的文件。单击确定，然后单击确定按钮。

Copy and paste the ldf & mdf file in [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\](it's my may be you have little different path.)

Data folder after that start your query analyzer click on Object Explorer and right click on database you will get attach option click on attach after that
you will get a window as attach database and click on add button select you file from Data Folder. click on ok and click on ok button.

这篇关于恢复ldf和mdf文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！