why is it not possible to find the database

  • Thread starter Thread starter Tony Johansson
  • Start date Start date
T

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
 
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.
Click to expand...

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.
 
Jeff Johnson said:
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.
Click to expand...

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
 
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 ?
Click to expand...

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....
 
Jeff Johnson said:
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....
Click to expand...

I found the file by asking sql sever.

//Tony
 
Jeff Johnson said:
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....
Click to expand...

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
 
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.
Click to expand...

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
 
Back
Top