I guess the OP had mentioned Clustering is not an option due to budget constraints.

Not yet ! 🙂

GilaMonster (2/5/2010)

---

Sure, it's fine for secondary reporting systems. It's just bad for hot...

Have you verified comparing the Database sizes of the Primary and the stand by database? If they are not nearly the same size, I would guess it is not restoring...

As Gail has pointed out, though Replication is listed / treated as one of the HA features, it would be cumbersome to implement it as a true DR or HA...

Alvin Ramard (2/5/2010)

---

CirquedeSQLeil (2/5/2010)

---

Alvin Ramard (2/5/2010)

---

Better yet, can we...

Remember that a backup of a lower version / patch level would work when tried to restore on a higher version / patch level. But the higher version / patch...

I second Jason's view, Standard edition should be suffice, unless you need DB Mirroring, Data compression, Database Partitioning and many other enterprise level features..

How are you performing this? Are you using just the Import/ Export Wizard or using script table and move it manually?

You would be better if you are using the generate...

Yes, as Jeffrey mentioned, it would rollback the insert. Rollback would also take some time depending on the # of records it has processed..

Yes there is a significant difference between Express Edition and Developer Edition, as Developer Edition would have every feature / option that is available in the Enterprise Edition (except that...

cafc (2/4/2010)

---

Hi again,

I think you didn't understand my question! first I using the sql server 2008 (as said before) and not sql server 2000! and second the solution for this...

SQL Compare from Redgate would be an option..

I don't have an SSAS Cube in SQL 2000 currently, so I can't try it and reply. But I would suggest you to take a look at performing it from...

That tutorial is a PHP Forms tutorial.. (Atleast when I open, may be it opens a different one (SQL Server) when you click :w00t: 😛 :hehe:)