使用其他名称还原数据库 [英] database restoring in a different name

问题描述

hi ..我想使用sql查询以其他名称还原数据库备份文件.请帮帮我..

与thnks和rgrds
ageesh ..

hi.. i would like to restore a database backup file in a different name using sql query. plz help me out..

with thnks & rgrds
ageesh..

推荐答案

首先运行查询以查找数据文件的逻辑名称

First run a query to find the logical name of the datafiles

Restore filelistonly from disk = ''d:\backup\Data.bak''

其中"d:\ backup \ Data.bak"应为您的备份名称

在备份集中应该显示逻辑文件名.

现在

Where "d:\backup\Data.bak" should be your backupo name

Which should show the Logical filenames in the backup set.

Now

Restore database Newdatabase from disk = ''d:\backup\Data.bak''
with move ''LogicalnameforMDF'' to ''d:\SQLData\NewDatabase.MDF'',
move ''LogicalnameforLDF'' to ''d:\SQLData\NewDatabase_Log.lDF'', stats

哪里
1."d:\ backup \ Data.bak"是您的备份名称
2."LogicalnameforMDF"是前面对MDF文件的查询中显示的逻辑名
3.磁盘(要还原数据的位置)上的物理文件名"d:\ SQLData \ NewDatabase.MDF"
4."LogicalnameforLDF"是逻辑名称，如先前对LDF文件(日志)的查询中所示
5."d:\ SQLData \ NewDatabase_Log.lDF"是日志的物理文件名

Where
1. "d:\backup\Data.bak" is your Backup name
2. "LogicalnameforMDF" is the Logicalname as shown in the previous query for the MDF File
3. "d:\SQLData\NewDatabase.MDF" physical filename on the disk(where the data to be restored)
4. "LogicalnameforLDF" is the Logicalname as shown in the previous query for the LDF File (Log)
5. "d:\SQLData\NewDatabase_Log.lDF" is the physical File name of the Log

这篇关于使用其他名称还原数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！