SQL RESTORE语法 [英] SQL RESTORE syntax

问题描述

sql中是否有任何错误

is there any error in sql

RESTORE FILELISTONLY
FROM DISK = 'E:\FuzzyRoute.BAK'
WITH MOVE 'Data_File' TO 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\FuzzyRoute_Data.mdf',
MOVE 'Log_File' TO 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\FuzzyRoute_Log.ldf',norecovery

推荐答案

是的，您的SQL语句中有错误.

命令RESTORE FILELISTONLY不会还原数据库，它只是为您提供备份文件中包含的文件列表.

这个位很好，但是之后的所有操作都是不允许的.

Yes there is an error in your SQL statement.

The command RESTORE FILELISTONLY does not restore the database it just gives you a list of the files contained in the backup file.

This bit is fine but everything after is not allowed.

RESTORE FILELISTONLY
FROM DISK = 'E:\FuzzyRoute.BAK'

查看仅还原文件列表 [还原数据库 [ ^ ].

Look at RESTORE FILELISTONLY[^] to see what is allowed.

To actually restore a database use RESTORE DATABASE[^].

这篇关于SQL RESTORE语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！