Backup database from the database attached with program in c# by programming

Question

When the connection string is like

Data Source=IMMENSE-01\\SQLEXPRESS;Initial Catalog=dipar;Integrated Security=True

I can use this query to backup database

backup database dipar to disk ='F:\DBBackup\dipar.bak' with init,stats=10

But when I keep the database along with the program to make a executable file, the connection string is like

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dipar.mdf;Integrated Security=True;User Instance=True

and the query to take backup backup database dipar to disk ='F:\DBBackup\dipar.bak' with init,stats=10 Says database not found.

Please help

Community · Accepted Answer · 2017-05-23 11:50:57Z

1

Sorry, my first answer was incorrect.

If you're using the AttachDbFileName= approach in your connection string, you cannot use BACKUP DATABASE since that database file is not really attached to the SQL Server Express instance. That's one of the many drawbacks and shortcomings of that approach – marc_s

From: How to create database backup, when DB not stored in Microsoft SQL Server?

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Jan 23, 2015 at 6:06

Lance

6541 gold badge6 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Backup database from the database attached with program in c# by programming

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related