I went back and looked at performance stats for an active\passive server pair doing some mirroring and some logshipping.

the load on the failover is a fraction of that on the...

definitely backup the system databases, in fact do it now.

In the maintenance plan there is an option to select system databases.

This does not include tempdb, as its name suggests thats...

still missing the points I think Steve :crying:

we were quoted 15% for enterprise edition, 25% for standard edition.

damn polarity reversals. Whos been misusing DBCC timewarp.

What a day, I've been called an a** and a j*rk and now I've lost points!

if you are logshipping you get i/o spikes as you load the logs, particularly write times on the drive holding the log files. Outside of those times logshipping has no...

well sort of, but lifes too short to quibble...................

our posts crossed. Exactly our point.

perhaps edit your previous post please?

Ninja's_RGR'us (2/17/2010)

---

I'm glad to not be a part of this anymore!

It seems like a legit question to me. If you think this is an interview question then just come...

I think we are being tested.

we used to do this on SQL2000 logshipping pairs (would also work with SQL2005 mirroring). Rather than an active\passive setup with one server being purely for failover we had some...

David Lean (2/17/2010)

---

So that reduces the discussion to orginisations that only buy their databases &/or s/w as a one off purchases.

quote]

which is all companies that want to upgrade and...

without a posted error I would hazard a guess its the owner of the job not being recognised.They will all have been set to run with your id, change them...

Thats a hell of a setup for a DEV server, can I have some of your budget? 🙂

You have a 300GB database but a 50Gb backup. You have 2008 enterprise...

jsb12 (2/16/2010)

---

yes George, this is part of DR, and its for restoring logs and also full backups. Regarding restoring the full backup part, I'm not too sure why.

Thank You Steve,...