In that case, follow Gail's advice. Record the peak log usage and shrink to that (leave a pad).

You'll have to provide some code and perhaps an execution plan to understand what you're doing here.

bcp will do a csv export of data. That should work.

If you can select the data in SSMS, you can save the grid results as a csv as well.

You are performing log backups, correct?

These help manage the size of the log.

I prefer R1 or R10, though I certainly understand economics.

If you convert to r5, and that might work fine for your workload, I wouldn't add 2 drives, I'd add 3...

First, I'd always restore with norecovery. If you make a mistake, you haven't caused an issue. Do all restores with that or STANDBY and once you are sure things are...

I bet that you could go to a kinkos and get them to print to fit on a large scale poster. They'd laminate it as well.

I know. I used to...

I assume you have operators set up, right?

Do you manually a job and not get an email? Have you checked the sent stuff?

http://technet.microsoft.com/en-us/library/ms191278.aspx

Doesn't task manager show cores?

systeminfo might be returning physical sockets. Licensing used to be by sockets, so that might what's returned.

Maybe that's a test to run. Can you...

Yep, I'd actually like a few of these.

If you can put something together that tests some of the various possibilities for code, whether this is a variety of parameters or...

I keep rooting for the Tigers. No dog in this fight, but never liked Boston.

Why don't you organize one? It's...

Gary Varga (10/18/2013)

---

I work freelance, often outside of any major city here in the UK, so I find it difficult to attend during the week. During the weekend I have...

Beatrix Kiddo (10/18/2013)

---

John Mitchell-245523 (10/18/2013)

---

Beatrix, where are you based? There should be a user group[/url] near you. There only about once a month, so it's not much of...