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 - 2005-01-25 : 08:16:47
|
| dvpo24 writes "Hi, I have query regarding attaching database.I have database created at my end for my application.Now I want to deploy my application at the client end and also I want to replicate the database at the client end.As far as I know the way to do this is "Detach and Attach" database.As per my knowledge,Once we detach database it is not available.I just want to copy the database at the client end and the same time I want the database at my end also.How can I do it?Am I correct if I detach the database and attach it at both the places(ie at client end and at my end).Please guide.Waiting for ur reply.Thanks in advance." |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-01-25 : 08:49:42
|
| Simplest & cleanest way would be to backup your database and then restore it at the client. That way you dont have to detach your database take a copy of the db files and then re-attach at your end & at the clientAndy |
 |
|
|
|
|
|
Query regarding attaching database