Get the name of db from sql express

Question

I have used this connection string to connect my sql database to sql express automatically:

Data Source=.\SQLEXPRESS; AttachDBFileName=|DataDirectory|\DB\MyDBName.mdf; User ID=sa;Password=MyPass;Persist Security Info=True

everything works fine, but the problem is when i want to get backup from my db.The sql express changes the name of db when attach it so in backup query i get this error:

Database 'MyDBName' does not exist.Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally.

My backup query is:

BACKUP DATABASE [MyDBName] TO DISK=N'" + filePath + "' WITH NOFORMAT, INIT, SKIP, NOREWIND, NOUNLOAD, STATS = 10;

Is there any way to get the current name of my db from sql express OR set the name of my db when attached automatically to sql express?

Zain Ul Abidin · Accepted Answer · 2017-09-18 04:42:28Z

1

First execute the following query and get database name

SELECT DB_NAME() AS DataBaseName

i.e

 SqlCommand cmd = new SqlCommand("SELECT DB_NAME() AS dbName",your_connection);
 string name = cmd.executeScalar().ToString();
 //now do what ever you want to with db name

answered Sep 18, 2017 at 4:42

Zain Ul Abidin

2,7601 gold badge23 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Get the name of db from sql express

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related