如何使用SQL查询从netwrok驱动器还原SQL数据库 [英] How to restore SQL database from netwrok drive using SQL query

问题描述

I am trying to Restore SQL DataBase from Network Device in SQL Query.I have tired below Query but its shows an error message as "Msg 3201, Level 16, State 2, Line 1 Cannot open backup device '\ARINDSQL\D-Drive\SQLBackup\Mis.BAK'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally." 

RESTORE DATABASE Mis
FROM DISK = '\\ARINDSQL\D-Drive\SQLBackup\Mis.BAK'
WITH MOVE 'Mis_Data' TO 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Mis.mdf',
MOVE 'Mis_Log' TO 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Mis.ldf'  

我尝试了什么：



我已尝试过以上查询但是它没有解决

What I have tried:

I have tried above Query but its not solved

推荐答案

错误信息非常明确：运行SQL Server的帐户没有读取备份文件的权限。



与网络管理员联系以更改该文件的权限，或将文件复制到SQL框上的本地文件夹。

The error message is quite clear: the account which SQL Server is running as does not have permission to read the backup file.

Talk to your network administrators to have the permissions on that file changed, or have the file copied to a local folder on the SQL box.

这篇关于如何使用SQL查询从netwrok驱动器还原SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！