我们怎样才能覆盖c#.net中现有的sql server数据备份文件? [英] How can we overwrite of existing sql server data backup file in c# .net?
问题描述
您好,
我通过c#.net备份sql server数据库,但我的数据库第二次没有覆盖。
我想每次都在按钮点击事件上覆盖数据库备份文件。
我的代码是:
con.Open();
SqlCommand cmd = new SqlCommand(backup database+ dbName +to disk =''+ DestDir +\ \+ dbName +。bak'',con);
cmd.ExecuteNonQuery();
con.Close();
怎么可能?
请帮帮我?
谢谢。
Ankit Agarwal
软件工程师
Hello,
I m taking backup of sql server database through c# .net, but my database did not overwrite on second time.
I want to overwrite database backup file on button click event every time.
my code is:
con.Open();
SqlCommand cmd = new SqlCommand("backup database " + dbName + " to disk=''" + DestDir + "\\" + dbName + ".bak''", con);
cmd.ExecuteNonQuery();
con.Close();
How could that possible?
Please help me?
Thank You.
Ankit Agarwal
Software Engineer
推荐答案
使用WITH FORMAT选项。请参阅: http://msdn.microsoft.com/en-us/library /ms191304(v=sql.105).aspx [ ^ ]
见下面的示例:
Use WITH FORMAT option. See: http://msdn.microsoft.com/en-us/library/ms191304(v=sql.105).aspx[^]
See sample below:
USE MyDB;
GO
BACKUP DATABASE MyDB
TO DISK = 'd:\backups\MyDB.Bak'
WITH FORMAT
GO
示例:
sample as:
USE MyDB;
GO
BACKUP DATABASE MyDB
TO DISK = 'd:\backups\MyDB.Bak'
WITH NOFORMAT, NOINIT, NAME = N'MyDB-FullBackup, SKIP, NOREWIND, NOUNLOAD, STATS = 10'
GO
这篇关于我们怎样才能覆盖c#.net中现有的sql server数据备份文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!