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 |
|
dcarva
Posting Yak Master
140 Posts |
 Posted - 2004-09-02 : 17:45:20
|
| Hello,I have an MSDE database on Server1. It was installed by some program. I need to move that MSDE database to another server, Server2. This company does not have SQL Server. Only MSDE. So I installed the MSDE program on Server2. Question is, once I copy the old database over to Server2, how do I attach it to the MSDE instance? If I had SQL Query Analyzer, I would try to attach it. How can I do this?Thanks,Danny |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-02 : 17:48:21
|
| You will need to use osql.exe which is a command line utility. You can run "Query Analyzer" commands from there. So go to Start..Run..Type in cmd and hit enter.Then:osql -SServerName -E<enter>1> commands go here2> after each command type go1> ...Tara |
 |
|
|
dcarva
Posting Yak Master
140 Posts |
Posted - 2004-09-02 : 17:50:32
|
| Excellent! Thanks |
|
|
|
|
|
|
Attaching databases