本文介绍了如何使用SQL查询从netwrok驱动器还原SQL数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
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查询从netwrok驱动器还原SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！