在SQLServer 2005中还原数据库错误 [英] Restore database error insqlserver 2005

查看:97
本文介绍了在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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆