如何从备份文件恢复备份？ [英] How do restore the backup from backup file?

问题描述

如何从现有备份文件恢复数据库？

How to restore the database from existing backup file?

推荐答案

Hai





试试这个链接



http://technet.microsoft.com/en-us/library/ms177429.aspx [ ^ ]



http://technet.microsoft.com/en-us/library/ms187048.aspx [ ^ ]



http://technet.microsoft.com/en-us/library/ms187048.aspx [ ^ ]



http://www.youtube.com/watch?v=fohy0bpz1A4 [ ^ ]





https://www.google.co.in/？ gfe_rd = ctrl& ei = FoweU5_6MeqJ8Qejp4GoCw& gws_rd = cr＃q = restore + backup + in + sql + server + 2008 [ ^ ]

Hai


Try this links

http://technet.microsoft.com/en-us/library/ms177429.aspx[^]

http://technet.microsoft.com/en-us/library/ms187048.aspx[^]

http://technet.microsoft.com/en-us/library/ms187048.aspx[^]

http://www.youtube.com/watch?v=fohy0bpz1A4[^]


https://www.google.co.in/?gfe_rd=ctrl&ei=FoweU5_6MeqJ8Qejp4GoCw&gws_rd=cr#q=restore+backup+in+sql+server+2008[^]

您好，

打开SQL Server.Locate存在备份文件的路径。现在右键单击数据库 - >选择Restoredatabase。然后会打开一个弹出窗口。现在选择一个设备中的单选按钮名称，然后浏览备份文件名yourdatabasename.bak。然后单击确定。就是这样。现在您的数据库将在数据库左侧窗格中可用。

Hi,
Open SQL Server.Locate the path,where the backup file is present.Now right click on database->select Restoredatabase.Then one pop up window will open.Now select one radio button name from device,then browse for backup file name "yourdatabasename.bak". Then click OK. That's it.Now your database will available in left pane under database.

To restore a database to a new location, and optionally rename the database

    Connect to the appropriate instance of the SQL Server Database Engine, and then in Object Explorer, click the server name to expand the server tree.

    Right-click Databases, and then click Restore Database. The Restore Database dialog box opens.

    On the General page, use the Source section to specify the source and location of the backup sets to restore. Select one of the following options:

       1- Database

       2 - Device
Click the browse (...) button to open the Select backup devices dialog box. In the Backup media type box, select one of the listed device types. To select one or more devices for the Backup media box, click Add.

After you add the devices you want to the Backup media list box, click OK to return to the General page.

In the Source: Device: Database list box, select the name of the database which should be restored.

在目标部分，数据库框自动填充要恢复的数据库的名称。要更改数据库的名称，请在数据库框中输入新名称。



在还原到框中，保留默认值为上次备份或单击在时间轴上访问备份时间轴对话框以手动选择停止恢复操作的时间点。有关指定特定时间点的详细信息，请参阅备份时间表。



在要还原的备份集网格中，选择要还原的备份。此网格显示指定位置的可用备份。默认情况下，建议使用恢复计划。要覆盖建议的恢复计划，您可以更改网格中的选择。取消选择早期备份时，将自动取消选择依赖于恢复早期备份的备份。



有关备份集中要恢复网格的列的信息，请参阅还原数据库（常规页）。



要指定数据库文件的新位置，请选择文件页面，然后单击将所有文件重新定位到文件夹。为数据文件文件夹和日志文件文件夹提供新位置。有关此网格的详细信息，请参阅还原数据库（文件页面）。



在选项页面上，根据需要调整选项。有关这些选项的更多信息，

In the Destination section, the Database box is automatically populated with the name of the database to be restored. To change the name of the database, enter the new name in the Database box.

In the Restore to box, leave the default as To the last backup taken or click on Timeline to access the Backup Timeline dialog box to manually select a point in time to stop the recovery action. See Backup Timeline for more information on designating a specific point in time.

In the Backup sets to restore grid, select the backups to restore. This grid displays the backups available for the specified location. By default, a recovery plan is suggested. To override the suggested recovery plan, you can change the selections in the grid. Backups that depend on the restoration of an earlier backup are automatically deselected when the earlier backup is deselected.

For information about the columns in the Backup sets to restore grid, see Restore Database (General Page).

To specify the new location of the database files, select the Files page, and then click Relocate all files to folder. Provide a new location for the Data file folder and Log file folder. For more information about this grid, see Restore Database (Files Page).

On the Options page, adjust the options if you want. For more information about these options,

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