jsciii (3/11/2010)

---

Good info everyone (especially the MS link).

It would appear there is no down side to mount points and even MS recommends them to avoid the dreaded drive letter limitation....

Cyberspy (3/11/2010)

---

I suggest you run it in your webpage and verify that it did not happen. It likely did occur for the hacker and the hacker will return at...

Oleg Netchaev (3/11/2010)

---

This is a very good article Jason, thank you.

When recovery model is full, proper handling of the log file growth is of utmost importance, and your article...

Thank you. I actually started out using...

Thank you.

Paul Randal (3/11/2010)

---

Good stuff Jason.

@medelstein From the (incredibly helpful, eh?) error, you're running the code on a SQL 2000 box, or in the context of a DB that set to...

medelstein (3/11/2010)

---

Hello,

I tried creating the runninSqlStatements stored procedure and it gives me a syntax error on this line:

CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) as qt

with this error:

Msg 102, Level 15, State...

arr.nagaraj (3/11/2010)

---

No. I prefer Jason's approach. Logging every small transaction is just pointless in the context of this article, as I have made clear already. You will just make it...

Unfortunately,...

Paul White (3/11/2010)

---

No. I prefer Jason's approach. Logging every small transaction is just pointless in the context of this article, as I have made clear already. You...

Let's keep in mind that the query I provide for recording the size is for SQL 2005 and 2008 (as stated in the article). To make this work on...

berber (with Scotchgard)

Did you try to run the dbcc shrinkfile without the truncateonly option?

Rug Doctor

A file should only be set offline when the file is corrupted, but it can be restored. A file set to offline can only be set online by restoring the...