Mr. Andersen (9/28/2010)

---

I'm working as a developer on a project that stores large amounts of data per transaction (Often 200 MB or more). After having committed or rolled back a...

Jamie Longstreet-481950 (7/21/2010)

---

Just a note - it is not necessarily correct that this error indicates a backup file is corrupt. There could be versioning issues here - example, try...

There is enough blame to go around on all sides.

1) The DBA made a request for disk space, but assumed that 1TB would be allocated across multiple spindles without specifying...

Ok, I figured out where to find the auditing information, Windows Event Viewer Security log.

I looked and I can see that the backups occurred (I'm looking at both the SQL...

I enabled Login Auditing on both failed and successful logins, but I am still not seeing who is kicking this off. All I see is NTAuthority\System.

Perhaps I am looking for...

Okay, as I continue to review this issue, the mystery continues to confuse.

Ran the scripting in an earlier post (Thank you, Michael) and I get some really fun results

DatabaseName ...

Steve Jones! :w00t:

Actually, I have checked there and nothing seems to point to a task scheduled on the Server. However, because there are a number of other SQL Servers with...

Homebrew,

I'm aware of that, but clearly neglected to mention it.

mckinnj1 (5/20/2010)

---

Thank you, that kind of solidified what I thought.

I could not understand the rebuild after the reorg...

Now, with that said, here are some follow up questions...

Would it be better...

mckinnj1 (5/20/2010)

---

Sorry to resurrect this issue...

Just looking for some general advice I suppose.

We have a database where the vendor has several daily stored procedures...

b_jvr (3/4/2010)

---

When logged in as this user (user01) it can select data from views & tables. It cant update or delete. This is all as it should be and as...

I recommend Dynamic Management Views (DMV's).

However, your question is a little broad. Are you trying to troubleshoot a performance issue or monitor when/if SQL Server goes down?

Performance issues are best...

Sometimes it is the little things that mess us up.

Michael, were you able to determine how the period got there in the first place? Was this a simple code error?...

Thanks for the ideas.

Since this is my client, I have little, if any, influence over what they decide to do with regard to their hardware. I can only make suggestions....

Eddie: Awesome writeup! It nice to have this forum because I learn tons more about SANs and such. Oh, and point taken regarding recoveries saving jobs over backups. It is...