LocalDB- master database , backup/restore feature

Question

I have a C#,.net application which connects to a SQLexpress database.

I am changing the database to localDB.Now there are couple features like

Database restore/backup - i have a common stored procedure in master and i call that for the same.
get all databases in the server instance

for both of them the connection string is something like

 "Data Source=ConfiguarionDB;Initial Catalog=master;Integrated Security=True;"

But since i am moving to localdb , what should be the connection string ?

"Data Source=(localdb)\\v11.0;AttachDbFileName= D:\\ConfiguarionDB.mdf;Initial Catalog=master;Integrated Security=True;"

which doesn't work!. I am able to load the database and perform all other operations which doesn't involve master db(ofcourse connection string doesn't involve master db)

Your given connection string for localdb having unwanted semicolan(;) at the end. — Mohd Sadham, Apr 17 '14 at 05:13
Isn't an MDF File a single DB? If so, wouldn't there be a different MSF for the MASTER? I don't know locvaldb: does it even have a master DB? — simon at rcl, Apr 17 '14 at 13:32

score 0 · Answer 1 · answered May 23 '16 at 06:50

0

Try your connection string without using Initial Catalog. Like this

"Data Source=(localdb)\v11.0;AttachDbFileName=D:\ConfiguarionDB.mdf;Integrated Security=True;"

answered May 23 '16 at 06:50

Nirali Maniar

46
6

LocalDB- master database , backup/restore feature

1 Answers1