So, you didnt notice that this was actually...

Did you try starting SQL in Single-User mode with the No-Recovery Trace Flag, and then dropping the database?

Stop SQL Server and SQL Agent,

Add -m and -T3608 to the SQL Server...

mpdillon (11/11/2010)

---

After reading the article I tried running the recommended resource at the bottom of the page, pr_rebuildindexes.sql. After cutting and pasting this into SQL Query Analyzer, I receive numerous...

george25 (11/10/2010)

---

I currently have a database with a 60Gb mdf and an 80Gb ldf. If I look at shrink file in SSMS it tells me that the available free...

SQL-DBA (11/10/2010)

---

Thanks for a great article. I don't typically read through 7 pages of comments but this one was worth it. I have to say though that some...

You can shrink TempDB; but I would recommend agqainst it if the server is very...

crainlee2 (11/9/2010)

---

Simon,

Here's the link to the Microsoft Technet article that I referenced: http://technet.microsoft.com/en-us/library/cc966523.aspx

Although it was originally focused on SS2000, through experimentation I've found that the results and recommendations in it...

SanDroid (11/9/2010)

---

I am really disappointed with this article and it's information.

Lots of it is directly from the BOL or other articles.

All it told me was:

SHRINKFILE BAD. Be afraid, it...

george25 (11/9/2010)

---

Simon

I've read loads of stuff about appropriate autogrowth increments. I get the fact that you should not use percentages but have never come to a proper conclusion about...

sjimmo (11/9/2010)

---

After reading and rereading the article, I am very disappointed in the simplicity that the writer takes in telling us about a very important issue, that of arbitrarily shrinking...

Joshua T. Lewis-378876 (11/9/2010)

---

In an effort to curb the necessity of shrinking, I have always taken a few steps whenever setting up a DB:

3.) Build two ldf files on any...

Unfortunately, No. The ShrinkFile command almost invariably causes data fragmentation.

I think I missed a very important point in the article - that SHRINKFILE on a Log file ISNT the performance killer that shrinking a data file is. The problems...

Do you have the link to that White Paper? I'd like to see that.

Thanks.

In response to Markus's comment - we have many clusters, ranging from 2-node A/A clusters to a 6-node N+1 (N Active / 1 Passive) cluster for our SQL instances, and...