Thanks Lynn! I took a look at the PASS 2012 site, and it looks interesting, especially after I browsed some of the sessions from 2011.

Now, if I could figure...

Thanks to both of you!

Jason A.

Lynn, you are absolutely right that if we were to do Differential backups, it would catch the updated filestream information. I was talking about my original thought of doing...

Leo.Miller (4/17/2012)

---

jasona.work (4/17/2012)

---

I realize we could take Differential backups throughout the week (Tue-Fri,) which would capture only the updated / changed / added Filestream information, but there are office politics...

If you download and install the SQL Server 2008 R2 Express with Advanced Tools, Management Studio does come with it.

Jason

I think (right now) I'd probably be a Ford Crown Victoria. Rugged, dependable, keeps on going no matter what crap gets thrown at it...

Why do you think the Crown...

A few possibilities to look into on this:

1. Are your systems both in an Active Directory Domain? Can you ping each server from the other by name NOT...

Thank you!

Now to get myself into the habit of using them...

Jason A

Thanks, I'll look at picking it up!

Jason A.

Tony Davis (1/30/2012)

---

My understanding is that the log chain starts at the last full DB backup. So if someone runs a full backup of the DB in the...

Megistal (1/27/2012)

---

First nice article!

Second, must I understand that the only way in SQL 2008 and Up to break the log chain is to switch to simple recovery model?

Pre-SQL Server 2008,...

Once more, thank you!

I'm poking around on Technet / MSDN now, trying to get a feel for those counters, and how to understand them.

Jason

Thank you!

I had forgotten about caching the various query plans, etc.

Is there any way to see what's currently in the caches, to see how much cache space query plans, etc...

I've often played the "what if" game about winning the lottery. I've always figured what I would do is first take 1/2 of every check and put it in...

About the only suggestion I could make, would be to either hide the script window, or if you need to be able to pull it up, minimize the window. ...