??

peteroc (11/26/2014)

---

Hi Jeff,

I'm with you regarding the adding more disk space but It's not my decision and I have to explore the options. I also think it's complicated by the...

Just double-check quickly that your server admin doesn't have something set up.

Errr... what explanation?

Order of columns doesn't matter in a table.

You might want to post this in an Oracle forum. This site is for Microsoft SQL Server, while we'll be able to get you a T-SQL function to do what...

Depends what index gets affected by this bug. Clustered = data.

But it doesn't matter, because you're going to apply the CU and hence won't be at risk...

Are you using some other form of full backup as well? SAN Snapshot? BackupExec? Something else?

What exactly do you mean?

Adding WITH EXECUTE AS OWNER means the contents of that procedure (and only the contents of that procedure) runs as the procedure's owner, probably dbo.

The permission missing is the...

Yes, the messages saying what's wrong with the file and why SQL is marking the database suspect.

Any chance you could translate that error?

The error log is more likely to have useful information than the transaction log.

Corruption is usually IO subsystem

Absolutely.

1) Identify your SLAs

2) Identify what needs to be included in the DR plan

3) Craft a plan to meet the above requirements.

If you're not comfortable putting something so critical together...

Probably easier to look in the transaction and lock DMVs