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-11 : 10:32:51
|
| Stephen writes "We have an sqlserver database held locally in our office. We also have the same database replicated in the states, which is used for a web site. Every 6 months, we need to synchronize the remote database with our local one.At the moment, we backup the local database, transfer the file, then restore it at the other end. This normally works okay, but sometimes fails. It would appear that the database has to be roughly the same size for this to work - is this correct? What if the new database is bigger - what then? Or could the problem be something else?Also, is the 'backup-restore' method the correct approach? How do others synchronize remote sqlserver databases?CheersStephen" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-11-11 : 10:36:36
|
| What is the error you are receiving? The databases do not have to be the same size for a restore operation to work. In this situation, yes the backup/restore method is the appropriate solution.***************************************Death must absolutely come to enemies of the code! |
 |
|
|
|
|
|
Exporting and importing an sql database