Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can not see the database
Message
General information
Forum:
Microsoft SQL Server
Category:
Security
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01300594
Message ID:
01300616
Views:
9
This message has been marked as a message which has helped to the initial question of the thread.
>>>>>
>>>>>Thanks a lot in advance.
>>>>>
>>>>>UPDATE. I see in web.config that we were using server database. But in any case, there was a local version of the database which I'm missing now.
>>>>
>>>>
>>>>Could you see it with SSMS?
>>>
>>>This is how I'm trying to see it. How else should I try?
>>>
>>>Should I try to search for MDB files?
>>
>>Is that database attached to your SQL Srever?
>>Did you have other instances?
>>On my computer I have a default instance (for developer edition) and SQLEXPRESS one (when I installed VS 2008).
>>Default location for DBs is \Program Files\Microsoft SQL Server (version here)\MSSQL.(instance number)\DATA
>
>I found some database files in MSSQL.1\MSSQL\Data. I found there AdventureWorks, for example, which I also don't see in SSMS. However, the database I was looking for is not there. I guess originally I was just connecting to the sever too and didn't notice that.

If you have MSSQL.1-4 that you have 4 instances of SQL Server installed. Just try to connect to each one and see where the data is.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform