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. ...

I've thus far not used either (hey, I still a noob...) But I have run into the exact situation as far as finding answers to problems goes...

I think this...

To some extent it does depend on who asks, but I generally start with:

Server Admin / Network Admin / Database Admin / Senior Support / General Flunky / Slave...

Sort of...

Thanks!

The Logical Name field in question, is in:

Database properties->Files

See the attached JPG, the section in question is in the red box.

I'm going to presume from where I found this, it...

If I win, can I bring my wife, and a curtain?

:ermm:

I may only be an "accidental" DBA, but I'm entering, if only for the chance to go for the ride...

To...

opc.three (10/7/2011)

---

jasona.work (10/7/2011)

---

I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell....

I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell. I...

Never mind, I figured out I could (and how) wrap the restore in a Try / Catch block. Now I just need to set about getting it to loop.

Thanks!

Jason...