代码之家  ›  专栏  ›  技术社区  ›  A G

sql server还原数据库

  •  0
  • A G  · 技术社区  · 14 年前

    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.
    

    谢谢。

    1 回复  |  直到 14 年前
        1
  •  2
  •   OMG Ponies    14 年前

    正在使用的用户帐户没有文件夹/文件的权限:

    在“C:\Program Files(x86)\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\XYZ\SQL.HDR”上尝试“OpenForRestore”时,操作系统返回错误“5(访问被拒绝)”。