文件扩展名为.file，用于恢复sql server中的数据。 [英] file with .file extension type to restore data in sql server.

问题描述

我有一个数据库备份文件。



文件类型：文件

文件扩展名：.file



我想要从上述文件中恢复数据。我该怎么做？



我只知道从.bak文件恢复db但是如何从type = file的文件中执行此操作。

Hi,

I have one DB backup file.

file type : file
file extension : .file

I want to restore data from above mentioned file. How can I do it?

I only know restoring db from .bak file but how to do it from file where type = file.

推荐答案

从设备恢复备份

连接到相应的Microsoft SQL Server数据库引擎实例后，在对象资源管理器中，单击服务器名称以展开服务器树。

展开数据库，并根据数据库选择用户数据库或展开系统数据库并选择系统数据库。

右键单击数据库，指向任务，然后单击还原。

单击所需的还原操作类型（数据库，文件和文件组或事务日志）。这将打开相应的还原对话框。

在常规页面的还原源部分中，单击从设备。

单击从设备文本框的浏览按钮，打开指定备份对话框。

在备份媒体文本框中，选择备份设备，然后单击添加按钮以打开选择备份设备对话框。 [[此处]选择文件类型BakupFile（*。Bak *，。tm）到ALL（*）文件和选择文件]]

在备份中在设备文本框中，选择要用于还原操作的设备。

To restore a backup from a device
After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
Right-click the database, point to Tasks, and then click Restore.
Click the type of restore operation you want (Database, Files and Filegroups, or Transaction Log). This opens the corresponding restore dialog box.
On the General page, in the Restore source section, click From device.
Click the browse button for the From device text box, which opens the Specify Backup dialog box.
In the Backup media text box, select Backup Device, and click the Add button to open the Select Backup Device dialog box.[[here Chnage the Select File Type BakupFile("*.Bak*",".tm") to ALL(*) File ans Select The File]]
In the Backup device text box, select the device you want to use for the restore operation.

我们无法分辨 - 我们不知道创建该文件的原因是什么。

据推测，您创建了备份 - 因此您知道用于创建备份的工具。所以使用匹配工具！



文件类型/扩展名不相关：文件类型是基于文件扩展名的人类可读描述，文件扩展名可以在以下位置更改将。这不会改变内容，也不会使任何特定的软件都可读。例如，我可以将jpeg文件的扩展名从myPic.jpg更改为mypic.xlsx，但Excel将无法打开它。

它很可能是一个正常的sql备份文件，它将以通常的方式恢复 - 但。file的扩展并没有告诉我们什么。这是重要的内容。

We can't tell - we have no idea what created the file in the first place.
Presumably, you created the backup - so you know what tool you used to create it. So use the matching tool!

The file type / extension isn't that relevant: the "file type" is a human readable description based on the file extension and the file extension can be changed at will. That doesn't change the content, and it doesn't make it readable by any particular piece of software. For example, I can change the extension of a jpeg file from "myPic.jpg" to "mypic.xlsx" but Excel will no be able to open it.
It's quite possible that it's a "normal" sql backup file, and it will restore in the usual way - but an extension of ".file" doesn't tell us anything. It's the content that matters.

这篇关于文件扩展名为.file，用于恢复sql server中的数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！