Originally posted by nabaig
Can a standby server work over remote sites?

I need to have a copy of all regional databases updated continuously at HQ as separate DB's. What is the best solution?
You can have Standby over remote server. First of all tell us whats the purpose of this task ? Just for High availability or You need to access those databases simaultaneously ? I mean you have any plans of using the HQ databases for user access ?

As Jmodic said Just for High availability means you can use Standby. If you want use your regional databases copied over to HQ and use 'em for user activity you are left with REPLICATION is the only option and you don't have the second option standby, as you know that standby can only be READONLY mode while primary is in use.

Hope this helps...