如何进行服务器数据库备份 [英] How to take backup of server database

问题描述

我想将服务器数据库备份到本地系统.我该怎么做，请帮帮我.谢谢您.
问候
Shibashish mohanty

I want to take backup of server database to my local system.how can i do that please help me.Thanks in Advance.
Regards
Shibashish mohanty

推荐答案

SQL Server允许在安装它的计算机上进行备份.

要恢复客户端计算机上的备份:

1)您应该在安装了sqlserver的服务器计算机上触发备份命令

2)您可以仅使用"ftp"或使用asp.net等下载"在客户端计算机上传输备份...

SQL server allows to take backup on computer on which it is installed.

To retreve backup on client computer :

1) you should to fire a backup command on server computer where sqlserver is installed

2) you can transfer backup on client computer using "ftp" or using "download" by asp.net etc only...

如果要通过代码进行备份，请参见此处:在C#中备份SQL数据库 [ ^ ]

If you want to do it from code, then see here: Backing up an SQL Database in C#[^]

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