我该如何使用BackUp [英] How do I take BackUp

问题描述

我想备份我创建的数据库visual studio 2010.需要快速回复。我尝试创建SP



ALTER PROCEDURE DBBackUp

/ *

（

@ parameter1 int = 5，

@ parameter2 datatype OUTPUT

）

* /

AS



- 添加SET NOCOUNT ON以防止来自

的额外结果集 - 干扰SELECT语句。

BACKUP DATABASE ExeDemoWithBackUp

要DISK ='D：\DatabaseBackUp \Billing.Bak'

WITH FORMAT，

MEDIANAME ='MyBilling'，< br $>
NAME ='账单完全备份';



返回



和还使用以下代码



// ServerConnection con = new ServerConnection（conn）;

//服务器服务器=新服务器（con） ;

//备份源=新备份（）;

//source.Action = BackupActionType.Database;

//source.Database =ExeDemoWithBackUp;

// BackupDeviceItem destination = new BackupDeviceItem（@D：\DatabaseBackUp，DeviceType.File）;

//source.Devices.Add （目的地）;

//source.SqlBackup(server）;

//con.Disconnect（）;



// String filePath = @D：\DatabaseBackUp;

// String databaseName =ExeDemoWithBackUp;



但我得到一个错误ExeDemoWithBackUp不存在。

请你在这里回复我或者你甚至可以分享我的博客



[LINK DELETED]

解决方案

试试这个：用C＃备份SQL数据库 [ ^ ]

Hi,



I want to take backup of my database which I had created in visual studio 2010. Need a quick response. I tried by creating SP

ALTER PROCEDURE DBBackUp
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
BACKUP DATABASE ExeDemoWithBackUp
TO DISK = 'D:\DatabaseBackUp\Billing.Bak'
WITH FORMAT,
MEDIANAME = 'MyBilling',
NAME = 'Full Backup of Billing';

RETURN

and also using the following code

//ServerConnection con = new ServerConnection(conn);
//Server server = new Server(con);
//Backup source = new Backup();
//source.Action = BackupActionType.Database;
//source.Database = "ExeDemoWithBackUp";
//BackupDeviceItem destination = new BackupDeviceItem(@"D:\DatabaseBackUp", DeviceType.File);
//source.Devices.Add(destination);
//source.SqlBackup(server);
//con.Disconnect();

//String filePath = @"D:\DatabaseBackUp";
//String databaseName = "ExeDemoWithBackUp";

but I am getting a error ExeDemoWithBackUp doesn't not exists.
Please you can reply me about this here or you can even share in My Blog

[LINK DELETED]

解决方案

Try this: Backing up an SQL Database in C#[^]

这篇关于我该如何使用BackUp的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！