1. install a SQL Express instance such as myexpress;
2. create some databases with tables such as db1 and db2;
3. Reinstall SQL Express with the same instance name "myexpress". I assume we need reinstall SQL Express myexpress again becuase of bad operations.
4. Open the myexpress by management tool but I can not see db1 and db2 databases but the datafiles and logfiles are in the data directory.
The question is what I need to do so I can consolidate exited databases so they can be seen in "myexpress" instance by management tool?
Hmmm it seems it has nothing to do with Team System, I would recommend you to ask this in the SQL Server forums, in which you will get more help for sure, sorry and good luck.
I also think the step you are not doing is an attach of the databases.
No comments:
Post a Comment