sqlserver和c＃之间的备份文件大小不同 [英] different backup file size between sqlserver and c#

问题描述

hi
i使用此语句在c＃中从数据库创建备份：

hi i use this statement for create backup from database in c# :

string query2 = @"BACKUP DATABASE [dbzolalmehr] TO  DISK = N'C:\Zolal DB Backups\dbzolalmehr-"+backup_date+".bak' WITH NOFORMAT, NOINIT,  NAME = N'dbzolalmehr-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10 ";

当此语句执行备份文件大小为3兆字节时

但是

当我在sql server中通过可视化工具进行备份时备份文件大小为9兆字节



优先为什么？

秒，是我的备份文件来自c＃完成且可靠吗？

请帮助..

when this statement execute backup file size is 3 Megabyte
However
when i do backup in sql server by visual tools backup file size is 9 Megabyte

first Why ?
second , is my backup files from c# complete and Reliable?
please help..

推荐答案

找出答案的最简单方法是进行测试恢复并看到（进入不同的数据库，优先...） - 你应该总是用测试恢复验证你的备份机制！



我这样做的方式就在这里：在C＃中备份SQL数据库 [ ^ ] - 和我知道这很有效。

The easiest way to find out is to do a test restore and see (into a different DB, by preference...) - you should always validate your backup mechanism with test restores anyway!

The way I do it is here: Backing up an SQL Database in C#[^] - and I know that works.

这篇关于sqlserver和c＃之间的备份文件大小不同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！