I want one.

henrik staun poulsen (3/14/2013)

---

Hi Steve,

We also almost never run CHECKDB.

This is because it takes tooooooo long.

I'm taking something above 50 hours.

When we restore a backup onto our test system, the...

The instance starting has nothing to do with the administrator. I'm asking if you can connect from SSMS with the administrator account, the same one used as the SQL Agent...

mtillman-921105 (3/12/2013)

---

'Thought I'd change my avatar to me - or something that looks a little like me. I haven't been around SSC much lately, work's been way too busy....

Is this a valid instance name? Is it started?

If you connect to the instance with the same administrator account, does it work?

Are you using the Configuration Manager to change accounts and set rights? You should be.

I would move to different physical drives, but I'd also do diagnostics. Depending on your situation, you could have firmware/filter drivers (as Gail mentioned) causing issues.

These are strange, hard to...

Corruption in the clustered index is likely a call to Microsoft. This is the data, and so you can't rebuild.

If I had this, I'd try to BCP out the data...

If the problem is still there, you have IO issues. It's not a SQL problem, but your hardware people are not running low enough level diagnostics, they don't know what...

Does this login have access to master? They have to be mapped to a user (or guest).

I might change it to a database that they have access in, say the...

Yep, should be treated like that. You can't handle it,...

They have offices all over. The requirement was...

paul.knibbs (3/7/2013)

---

I think there's another possible reason to not want to work from home. Speaking personally, I like to keep home and work in their own separate compartments--I'll work from...

Todd Carrier (3/12/2013)

---

I like your idea Steve.

...

A database calling it's own backup? Just sounded like a terrible idea to me, for some of the same reasons stated...