SQL database backup with entity framework 6

Question

string dbname = _dbContext.Database.Connection.Database;

const string sqlCommand = @"BACKUP DATABASE [{0}] TO  DISK = N'{1}' WITH NOFORMAT,
    NOINIT,  NAME = N'MajesticDb-Ali-Full Database Backup',
    SKIP, NOREWIND, NOUNLOAD,  STATS = 10";

int path = _dbContext.Database.ExecuteSqlCommand(System.Data.Entity.TransactionalBehavior
    .DoNotEnsureTransaction,
    string.Format(sqlCommand, dbname, "MajesticDB"));

I am using this code to make a database backup. It's working fine but this code is replacing the previous file with the new one. How do I change it so it doesn't?

what exactly is your question?

Nino
– Nino

2016-05-06 07:34:26 +00:00
Commented May 6, 2016 at 7:34 — Nino
– Nino, Commented May 6, 2016 at 7:34
Are you overwriting db backup with the same name?

Fanjo Lama
– Fanjo Lama

2016-05-06 07:38:06 +00:00
Commented May 6, 2016 at 7:38 — Fanjo Lama
– Fanjo Lama, Commented May 6, 2016 at 7:38
Yes its overwriting. I want to save new one every time

Rana Ali
– Rana Ali

2016-05-06 07:39:14 +00:00
Commented May 6, 2016 at 7:39 — Rana Ali
– Rana Ali, Commented May 6, 2016 at 7:39
@RanaAli Add datetime with your db name.

Fanjo Lama
– Fanjo Lama

2016-05-06 07:41:30 +00:00
Commented May 6, 2016 at 7:41 — Fanjo Lama
– Fanjo Lama, Commented May 6, 2016 at 7:41

VansFannel · Accepted Answer · 2017-09-07 08:36:49Z

2

Try like this.

string dbname = _dbContext.Database.Connection.Database;
string dbBackUp= "MajesticDB" + DateTime.Now.ToString("yyyyMMddHHmm");
const string sqlCommand = @"BACKUP DATABASE [{0}] TO  DISK = N'{1}' WITH NOFORMAT, NOINIT,  NAME = N'MajesticDb-Ali-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10";
int path= _dbContext.Database.ExecuteSqlCommand(System.Data.Entity.TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, dbname , dbBackUp));

edited Sep 7, 2017 at 8:36

VansFannel

46.2k119 gold badges382 silver badges657 bronze badges

answered May 6, 2016 at 7:46

Fanjo Lama

5813 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Draken Over a year ago

This line is incorrect

int path= _dbContext.Database.ExecuteSqlCommand(System.Data.Entity.TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, dbBackUp, "MajesticDB"));

Draken Over a year ago

I think you meant to put dbBackUp and not "MajesticDB", since at the moment you are not renaming your database backup

Fanjo Lama Over a year ago

@Draken Edit done. Typing mistake thanks for noticing. Sorry for late reply and edit.

VansFannel · Accepted Answer · 2017-09-07 08:37:00Z

1

you can try something like this:

string backupname= "MajesticDB" + DateTime.Now.ToString("yyyyMMddHHmm");
 const string sqlCommand = @"BACKUP DATABASE [{0}] TO  DISK = N'{1}' WITH NOFORMAT, NOINIT,  NAME = N'MajesticDb-Ali-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10";
       int path= _dbContext.Database.ExecuteSqlCommand(System.Data.Entity.TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, dbname, backupname));

this way, to backup name "MajesticDB" is appended date and time, so every time you call your backup procedure, database will be backed up with different name.

edited Sep 7, 2017 at 8:37

VansFannel

46.2k119 gold badges382 silver badges657 bronze badges

answered May 6, 2016 at 7:43

Nino

7,1152 gold badges29 silver badges46 bronze badges

Collectives™ on Stack Overflow

SQL database backup with entity framework 6

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related