You've got an I/O issue by the sounds. What type of storage config are you using? As Gail's stated you'll need to spread across physical spindles (which are not necessarily...

How often are you taking t-log backups on your production DB?

Carlton.

Believe you've answered this yourself: looks...

Speak to your SharePoint lot and ask them if there is any archiving etc that goes on, also if there was an estimated size and growth forecast when this went...

Is this a prod or dev (or other) system?

What's actually growing? .ldf? .mdf? both?

Sharepoint can be a right orge of a thing to manage in the SQL space.

Check recovery models,...

I second the storage comments (and demeanour of people administering them).

Carlton.

Another bug vote here, and another wrong answer for me.

NULL is NULL...fullstop. You never know what NULL is so regardless if you insert, concatenate, stick it somewhere in the string:...

In relation to the: "The answer lies in a bug in the cluster installer for SQL2008".

Does this bug exist in R2 aswell?

Carlton.

Ludo Bernaerts (3/25/2011)

---

great article but I have a question.

I configured a sql instance like mentioned in the article and see all connections coming in with Kerberos auth.

However the connections coming...

try: sp_removedbreplication

Carlton

Restore from backup is probably your preferred option if possible. I take it you have recent backups?

Carlton.

http://www.msdn.com

Carlton.

Search for the object id within the DB that is experiencing the blocking...

Carlton.

Plenty of ways to skin a cat...

Have a play with sp_MSForeachdb and sys.database_files.

Carlton.

Gift Peddie (2/25/2011)

---

grahamc (2/25/2011)

---

Its quite possible that your datasource is setup to impersonate the calling user - local admin. Which would (and should) not have permissions on the DB.

In the...