Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-27 : 11:58:44
|
| abel writes "How do I attach database file that used to be attached to a different SQL 6.5 server. The SQL 6.5 Server was retired years ago and the DB has been saved but not used ever since. Now I'm interested in viewing the file (mostly the table structures and relationships) but have been unable to open it. I created a SQL 6.5 server just for this purpose but nothing seems to work and I haven't been able to find help on the Books Online. There is no dump or backup of this file, only the original file (the one inside the mssql\data folder)." |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-02-27 : 12:14:26
|
| as far as i remember you need to recreate the devices and databases in the same folders as the original and preferably of the same size as well. Do you have this info. ?? From there i think you can replace the datasbase file with your older one. Worth a try anyway. I searched this site for other info. on it but couldn't find anything quite relevant. Perhaps try a search yourself, there's a lot of stuff here. |
 |
|
|
|
|
|
SQL 6.5 Server DB file into a different SQL 6.5 Server