sql server还原数据库

Question

从我的托管帐户备份数据库。使用以下脚本进行恢复。

RESTORE DATABASE [XYZ] 
FROM DISK = N'E:\Online Website Backup\_db_backups\XYZ.bak' 
WITH FILE = 1, MOVE N'XYZ' TO N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\XYZ.mdf', 
MOVE N'XYZ_log' TO N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\XYZ.LDF', 
MOVE N'sysft_XYZ' TO N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\XYZ', 
NOUNLOAD, REPLACE, STATS = 10 
GO 

收到以下错误

Msg 3634, Level 16, State 1, Line 1 
The operating system returned the error '5(Access is denied.)' while attempting 'OpenForRestore' on 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\XYZ\SQL.HDR'. 
Msg 3156, Level 16, State 2, Line 1 
File 'sysft_XYZ' cannot be restored to 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\XYZ'. Use WITH MOVE to identify a valid location for the file. 
Msg 3119, Level 16, State 1, Line 1 
Problems were identified while planning for the RESTORE statement. Previous messages provide details. 
Msg 3013, Level 16, State 1, Line 1 
RESTORE DATABASE is terminating abnormally. 

感谢。

Answer 1

使用没有权限的文件夹/文件中的用户帐户：

操作系统返回了错误“5（拒绝访问。）”试图对“C“OpenForRestore”： \ Program Files（x86）\ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ FTData \ XYZ \ SQL.HDR'。