在SQLServer 2005中还原数据库错误 [英] Restore database error insqlserver 2005
本文介绍了在SQLServer 2005中还原数据库错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已还原数据库
我曾经使用过查询
使用replace
从disk =''E:\ project \ DataBase''恢复数据库FinanceManagement
i have restore a database
i had use query
restore database FinanceManagement from disk=''E:\project\DataBase'' with replace
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device ''E:\project\DataBase''. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
推荐答案
再次,错误消息是不言自明的-您正在尝试使用没有权限的目录.
请尝试阅读您的错误!
Once again, the error message is pretty self-explanatory - you are trying to use a directory you do not have permissions for.
Please, try reading your errors!
权限错误....
如果您的帐户没有足够的权限访问网络驱动器,则不能将数据库备份到网络驱动器 [ ^ ]
无法打开备份设备"F:\ foldername".操作系统错误5(访问被拒绝.) [ ^ ]
如何备份和还原Microsoft SQL Server 2005上的数据库 [
Permission error....
You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive[^]
Cannot open backup device ''F:\foldername''. Operating system error 5(Access is denied.)[^]
How to backup and restore database on Microsoft SQL Server 2005[^]
这篇关于在SQLServer 2005中还原数据库错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文