将数据库备份到远程服务器 [英] backup data base to remote server

问题描述

hi

请帮我，我想在本地计算机上备份sql server 2005数据库.

hi

please help me i want to backup sql server 2005 database in local machine how it can possible

推荐答案

SQL数据库在哪里?是否要将其从服务器备份到本地计算机?您不能为此使用ASP.NET，除非您仅编写备份并将其作为下载发送.您需要更具体地了解您想要什么.数据库在哪里，服务器在哪里，什么是本地计算机"，以及您要如何执行此备份?

Where is the SQL database ? Do you want to back it up from your server to a local machine ? You can''t use ASP.NET for that, unless you just write a backup and send it as a download. You need to be more specific about what you want. Where is the DB, where is the server, what is the ''local machine'' and how do you want to do this backup ?

亲爱的朋友
如果您使用sql server express，我认为没有办法从远程服务器备份到本地系统.
但请尝试以下方法.
创建2个工作计划，
一个用于执行sql脚本以将数据库备份到服务器中共享文件夹中的文件.
第二个用于执行批处理文件以将文件复制到本地共享文件夹.
只需尝试一下.

dear friend
if u r using sql server express, i dont think there is a way to take backup to local system from remote server.
but try the following method.
create 2 job schedules,
one for executing sql script to backup the database in a shared folder in the server.
second for executing batch file for copying the file to local shared folder.
just give a try.

这篇关于将数据库备份到远程服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！