MSSQL数据库备份和还原 [英] MSSQL Database Backup and Restore

问题描述

我想备份和还原mssql数据库.我将使用asp.net C#.首先，我将登录到该项目.有一个数据库备份和还原UI.然后，我将当前数据库从远程数据库服务器备份到本地PC中.之后，我将还原它.
有谁可以帮我吗?我需要C#和SQL代码.

在此先谢谢您.

Hi,

I want to backup and restore mssql database. I will use asp.net C#. At first I will login into the project. There is a DB backup and restore UI. Then I will take a backup the current database from remote database server into my local pc. After that I will restore it.
Is there any one to help me?I need the c# and SQL code.

Thanks in advance.

推荐答案

您尝试搜索吗?如果是这样，您将发现以下内容:使用VB.NET和SQL-DMO(新版本)的SQL Server数据库备份实用程序 [ ^ ].

如果您确实需要转换为c#，应该不太困难.

Did you try searching? If so, you would have found this: SQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)[^].

Shouldn''t be too hard to convert to c# if you really need to.

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