数据库备份文件(如何还原)

本文介绍了数据库备份文件(如何还原)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有数据库备份文件，但是我没有从文件夹选项中检查文件扩展名，但是扩展名却没有显示出来，但是仍然看不到该文件具有什么扩展名? 在文件系统(驱动器D :)"中，键入:该文件即将出现. 无法附加和还原该文件:( 在Advance中致谢

I have database backup file but extension is not being coming up while i have unchecked file extension from folder options but still unable to see what extension that file have? In File System(Drive D:) , Type: File is coming up for that file. Unable to attach and restore that file :( Thanks in Advance

推荐答案

可能是，当您保存它时，您将覆盖该扩展名并且没有给出任何扩展名-因此将其另存为 Probably, when you saved it yoU overrode thE extension and didn''t give it any - so it is saved as Filename

而不是

Filename.ext Filename.bak Filename.sql

或类似名称. 在Windows资源管理器中查看文件，然后打开组织"下拉菜单. 选择文件夹和搜索选项"，然后选择查看"标签. 取消选中隐藏已知文件类型的扩展名"复选框，然后单击确定". 所有文件将如何显示完整的文件名，包括任何扩展名. 我想您会发现您什么都没给.重命名该文件，并在设置扩展名时反转以上内容.

Or similar. Look at the file in Windows Explorer and open the "Organise" drop down. Select "Folder and Search Options" and then the "View" tab. Untick the "Hide extensions for known file types" check box and click "OK". All the files will how show the full filename including any extension. I think you will find you didn''t give it any. Rename the file, and reverse the above when teh extension is set.

没有为sql当前用户分配权限. 我已经解决了:) There were not assigned to permissions to sql current user. I have solved :)