如何将实时SQL DB备份带到我的本地系统 [英] How to take live sql db backup to my local system

问题描述

亲爱的所有人

我需要将活动的sql db数据库备份到本地系统...如何获取.bak文件，请帮助我.....

当我使用此代码时，将出现如下错误消息:-

dear all

I need take my live sql db backup to my local system... how can i get the .bak file pls help me.....

when i use this code will appear a error message like this :-

// Sql Query

backup database rh_bookmany
to disk =''E:\rh_bookmany.bak''
with name=''rh_bookmany'' ,
     noformat ,
     init     ,
     skip     ,
     norewind ,
     nounload ,
     stats=10

////Error Msg

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ''E:\rh_bookmany.bak''. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

推荐答案

提示在消息中:

The clue is in the message:

Cannot open backup device 'E:\rh_bookmany.bak'. Operating system error 5(Access is denied.)

尝试将文件放在程序确实具有写权限的位置...
如有必要(这不是一个坏主意)，请创建一个专门用于备份的文件夹，并设置权限.

Try putting the file somewhere that the program does have write access to...
If necessary (and it''s not a bad idea) create a folder especially for the backups, and set the permissions.

亲爱的wahab，

无法备份实时服务器.在您的查询中，您尝试获取本地路径，但是我们无法作为本地计算机访问实时服务器...


如果需要备份，则必须联系实时服务器管理员
.


希望对您有帮助

dear wahab,

it is not possible to get the back up of the live server. in your query you trying to get local path but we can''t access the live server as local machine...


if you need the back up you have to contact the live server admin
.


Hope this will help you

这篇关于如何将实时SQL DB备份带到我的本地系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！