Click here to Skip to main content
15,896,338 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 ";


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..
Posted
Comments
Mehdi Gholam 1-Nov-14 10:09am    
Try restoring your backup no a new database and see if all your data is there.

1 solution

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.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900