I really think this could have been several times better.

JK Wayne

Nice Job;-)

dbursey (5/6/2013)

---

I don't recall anyone saying the question was trivial - my recollection is that someone noted that for someone with his apparent level of experience, it seemed that there...

Jon.Morisi (5/6/2013)

---

I've done a lot of cut overs like this using both mirroring or log shipping. Both work just fine, it's really just a matter of what you're most...

Despite the SP difference, are you using the Lightweight pooling?

Hugo Kornelis (5/6/2013)

---

If that is...

You can do a copy only backup or a regular full backup. If you are doing differential database backups on that server, then you would want to do a...

dbursey (5/5/2013)

---

I've most certainly (MOST CERTAINLY) asked my share of dumb questions, but...wouldn't you at least try logging in first? Okay, I had a laugh..it was good. Now I have...

GilaMonster (5/5/2013)

---

I've...

Running the checkpoint has nothing to do with the transaction rollback caused by the error you encountered. Rollback would have been automatic

Jeff Moden (5/5/2013)

---

dndaughtery (5/3/2013)

---

I agree but in this case its with an adhoc dev enviroment which its ok. If someone could explain to me how to go about it I...

Your transaction would have been rolled back. Re-issuing the command would have been the right thing to do.

I recommend getting a copy of SQL Server Developer Edition if you want to play with the BI tools.

I have seen those demos as well. What I think the takeaway from them is

1. Logging should be stored on a different system

2. Monitors should be in place (HIPS)...

Ninja's_RGR'us (5/4/2013)

---

How many situations have you NEVER encountered? ...

There is a Surface Area Configuration facet in PBM as well as a Server Configuration Facet. Both of these have the XPCmdShell check to see if it is enabled....