why is it not possible to find the database

[Tony Johansson]

I bring up the Server Explorer in VS08 and right click on Data Connection
and select "Create New Sql Server Database..."
and give server name which is homepc\sqlexpress and then give a database
name. If I now login to SQL Server 2008 express I can see these created
databases which is correct.

Assume I call the database Testing and search for testing.* in explorer no
file with a name starting with Testing can be found
this is strange. I have always found I name for the database like extension
mdf or sdf.

So why is there no file with the name Testing.

//Tony

 

[Jeff Johnson]

I bring up the Server Explorer in VS08 and right click on Data Connection
and select "Create New Sql Server Database..."
and give server name which is homepc\sqlexpress and then give a database
name. If I now login to SQL Server 2008 express I can see these created
databases which is correct.

Assume I call the database Testing and search for testing.* in explorer no
file with a name starting with Testing can be found
this is strange. I have always found I name for the database like
extension mdf or sdf.

So why is there no file with the name Testing.

This has nothing to do with C#, but I'm in a good mood....

Try looking for "Testing_Data.*". Actually, go get a good file search app (I
recommend Agent Ransack) and just search for "testing" so you find that word
wherever it is in the file name.

 

[Tony Johansson]

This has nothing to do with C#, but I'm in a good mood....

Try looking for "Testing_Data.*". Actually, go get a good file search app
(I recommend Agent Ransack) and just search for "testing" so you find that
word wherever it is in the file name.

This is strange I search for *testing*.* and I this works but I didn't get
any file that has anything to do with the database.
I got some other matching like xmltesting and testing2 and so on
The database file must be located somewhere but where ?

//Tony

 

[Jeff Johnson]

This is strange I search for *testing*.* and I this works but I didn't get
any file that has anything to do with the database.
I got some other matching like xmltesting and testing2 and so on
The database file must be located somewhere but where ?

I really don't know. I work with full-blown SQL Server, not Express, so I'm
not familiar with the files Express creates. I would assume a Google search
of terms like "sql express associated files" might give some promising
results....

 

[Tony Johansson]

I really don't know. I work with full-blown SQL Server, not Express, so
I'm not familiar with the files Express creates. I would assume a Google
search of terms like "sql express associated files" might give some
promising results....

I found the file by asking sql sever.

//Tony

 

[Tony Johansson]

I really don't know. I work with full-blown SQL Server, not Express, so
I'm not familiar with the files Express creates. I would assume a Google
search of terms like "sql express associated files" might give some
promising results....

This is really strange the file is located at
C:\Program\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\testing.mdf
Now if I position the search at program folder the file is found BUT if I
start the search from C:
the file is not found so I assume that the search has a limitation in how
many levels is can search

I can't find any other solution to this strange problem.

//Tony

 

[Arne Vajhøj]

This is really strange the file is located at
C:\Program\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\testing.mdf
Now if I position the search at program folder the file is found BUT if I
start the search from C:
the file is not found so I assume that the search has a limitation in how
many levels is can search

I can't find any other solution to this strange problem.

There are probably some logic.

If you use your own search utility written in C#, then it would
be on topic to troubleshoot.

If it is a Windows utility, then there are better groups for help.

Arne