SQL Server完全备份问题 [英] Sql Server full backup problem

问题描述

我的查询如下..

My Query is given below..

BACKUP DATABASE gsm
TO DISK = 'E\Backups\AdventureWorks.BAK'

和
错误消息:

and
Error Message:

Cannot open backup device 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\E\Backups\AdventureWorks.BAK'. Operating system error 3(The system cannot find the path specified.).

有什么解决方法吗?

is there any solution?

推荐答案

亲爱的朋友，

此错误意味着SQL Server无法访问指定的设备.因此，在为Folder赋予适当的特权后，

请也参考此链接:-

Dear Friend,

This error means that SQL Server just can''t get access to specified device.So after giving proper privileges to Folder

Please refer to this link also:- http://blog.sqlauthority.com/2011/12/17/sql-server-fix-error-msg-3201-level-16-cannot-open-backup-device-operating-system-error-3-the-system-cannot-find-the-path-specified/[^]

Please try this:-

BACKUP DATABASE gsm
TO DISK = ''E:\Backups\AdventureWorks.BAK''

**如果E:\驱动器存在，则仅

谢谢

**If E:\ Drive exists then only

Thanks

这篇关于SQL Server完全备份问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！