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-11-05 : 08:39:17
|
| Etgar writes "Hi there.I have 2 Computers which every one of them have SQL server.I want 2 copy a database between them.I try the backup option but it say I have file missing, and I Understood It's have problems with the "master" DB.PLZ help!!! |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-11-05 : 09:00:57
|
| What errors do you get exactly?It can be a question of different Sort Order if you are on SQL 7.Anyway you have other possibilities:1 sp_detach_db + sp_attach_db.2 DTS between the 2 computers.HTHFranco |
 |
|
|
|
|
|
Copy Database between 2 local SQL server