It will all depend on your availability requirements.

Mirroring has an intrinsic "limitation" and it is that if you plan on doing automated failovers and you use a multiple DB solution...

Been there... I have used logshipping instead of DB Mirroring.

Depending what kind of subscription you want (pull or push) follow the appropriate link:

http://msdn.microsoft.com/en-us/library/ms147905(SQL.90).aspx

Lynn Pettis (2/2/2009)

---

Oh, right, the World Cup is the only TRUE World...

O M G !

There are **so many** things to do regarding databases that it is hard to tell from where to start.

Databases are here to stay. There are many different opinions on how...

Is this a never-ending thread?

If Joe...

Fernando (2/2/2009)

---

:w00t: Thanks, the article in MIcrosoft was very enlightening!!! By the way, I will use backup as well. We use SQL Backup from Red-Gate for all our backups...

You need to use SQL 2005 UI tools.

OR

use stored procedures to set it up.

1) start again

Or Homework ? 😉

Jean-François Bergeron (2/2/2009)

---

You mean I should update the "Key" field depending on the value that has been updated in the Vendor Table? This makes no sense performance-wise... How am I...

Roy Ernest (2/2/2009)

---

Yep.... It is not that bad epending on your latency..:-) If the latency is high, then it will be easy to fly over with the disk to Europe...

Something is KILLing your connection!