Perry Whittle (9/6/2011)

---

get a VM up should take no more than a...

LutzM (9/6/2011)

---

The cost saving in terms of hardware most probably is not significant enough to be measured in $$$. Total processing time is about 30min/day before and after.

Is there any...

adb2303 (9/6/2011)

---

It looks as though you should be okay.

msdb.dbo.backupset has a foreign key constraint on backup_set_id with msdb.dbo.backupfilegroup, so as long as you restore the associated rows, I...

You might also check if you have traces or logging going on in the sql folders. Those can eat up a lot of room in no time flat.

How could it possibly work? the value is auto-generated & maintained by the server!

BEGIN TRAN

CREATE TABLE dbo.Boom (a...

GSquared (9/2/2011)

---

Ninja's_RGR'us (9/2/2011)

---

Yup, nice...

Please post the actual execution plan along with table DDL.

Assuming that's all there is to it I'm not seeing much hope for massive improvements.

Edit : And how long is way...

Cadavre (9/6/2011)

---

It doesn't, just a warning that it's...

The only good metric I've seen work on a CTO was total processing time.

I was able to say I've saved a total of 45 X 24 hours non stop processing...

adb2303 (9/6/2011)

---

I inserted the contents of old_msdb.dbo.restorehistory into msdb.dbo.restorehistory without any problems. Do you have a particular table in mind you want to recover? I don't mind breaking...

Agreed but this is 2k5 and I don't see how it would solve the issue at hand ;-).

Pagan DBA (9/6/2011)

---

I wish it was tooth fairy. Then I could blame someone else.

"Log File Full" is the correct answer to your question. It got full multiple times. Any way...

faling with what?

Log full?

Deadlock???

Tooth fairy out of cash because of economy??

Thanks, I forgot to mention...

WayneS (9/6/2011)

---

Now that is a great...