开发者

SQL Server 2008 external disc back-up

开发者 https://www.devze.com 2023-03-28 03:54 出处:网络
I have an external network back up disc mapped at Y:\\ , when I try to create back up on disc Y:\\ I have

I have an external network back up disc mapped at Y:\ , when I try to create back up on disc Y:\ I have

BACKUP DATABASE [DATABASE_NAME] TO  DISK = 'Y:\backup\backup.bak' WITH NOFORMAT, INIT,  NAME = @BackupName, SKIP, NOREWIND, NOUNLOAD,  STATS = 10

when I run it following error occurs

Msg 3201, Level 16, State 1, Procedure sp_backup, Line 10 Cannot open backup device 'Y:\backup\backup.bak'. Operating syste开发者_StackOverflow中文版m error 3(Path not found.).


Use a UNC path (e.g. \\server\share\backup\backup.bak). Whilst you may have the Y drive mapped, the user account that SQL Server is running under doesn't. And it's that "user" that is going to perform the data access.


It is possible that there is no folder 'backup' on drive Y: Or your account haven't appropriate permissions to this folder.

0

精彩评论

暂无评论...
验证码 换一张
取 消