...And thou shalt count to three. Not to four, which is greater...

Best piece of advice on this thread yet.

GilaMonster (10/6/2010)

---

Brandie Tarvin (10/6/2010)

---

I do have to ask this. You have full database backups scheduled, but it's not backing up the MDF file?

How do you know it's not backing...

liewsb (10/6/2010)

---

We have a schedule job to do a full backup on the database, but not these two file, i.e. MDF and LDF files. How to create a transaction log...

Definitely follow Gail's advice. She's rescued more databases than the Humane Society has rescued pets.

FYI: If you're not doing transaction log backups and you're in FULL or Bulk-Logged recovery model,...

No. I find it professional and well-reasoned. It is the correct and necessary response to the question.

In regards to another post / thread:

Here's the latest SQL Server version list, including 2k8 R2.

And for those who don't like clicky links: http://www.sqlteam.com/article/sql-server-versions

Sinus infection

...maybe.

Chris Morris-439714 (10/6/2010)

---

More??? The next question is...

You could always set up a DDL trigger (I think) to log any DROP DATABASE commands and even to prevent the drop of any database.

I'm not sure if it'll work...

Craig Farrell (10/5/2010)

---

GilaMonster (10/5/2010)

---

Alvin Ramard (10/5/2010)

---

That's the opposite of:

Q: How do you put an elephant in a...

Version List HERE gives all version #s, including R2.

Definitely tell them you need the client tools installed to your local box. If you need to develop, ask them for the...

Oh, is that a promise? I could use a few more cadavers...

@=)

New office game.

Requires 1 dartboard, 1 set of darts, 1 project plan.

Cut up project plan by milestones. Paste lesser milestones around the edges of the dartboard ring, paste the bigger...

I read the topic. Apparently, I'm not getting the joke about the OP, though.