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 |
|
hansbovenkamp@tiscali.nl
Starting Member
2 Posts |
 Posted - 2007-11-14 : 07:03:13
|
| Hi,I created a database on machine A, named ABC.mdfnot totally satisfied I started again on machine B, again naming it ABC.mdfI Then Detached ABC.mdf from machine A, deleted the data- and log fileThen tried to attach the ABC.mdf ( created on machine B ) to SQLserver on machine A and failed. ( both machines run SQLServer 7 )Can anyone please point me into the right direction?ThanksHans |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 07:12:07
|
| What was the error? Are both servers the same collation?Why not do a backup and restore? |
 |
|
|
hansbovenkamp@tiscali.nl
Starting Member
2 Posts |
Posted - 2007-11-14 : 07:31:15
|
| Hi, thanks for responding.When I went through all the steps again to document it so I could answer your question I noticed that I had renamed the files to ABC2.mdf etc.When I undid that change I was able to attach.Without your question I wouln't have revisited that area,ThanksHans |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 08:33:19
|
| no probs. Good luck.Dave |
|
|
|
|
|
|
Can't attach a database