You might be able to take a tail-log backup by switching to Emergency mode, but no full or diff, and you probably wouldn't want to backup a corrupt database.

n.heyen (1/6/2016)

---

So if the data and logs are on different drive letters but the drive letters all point back to the same controller and disks, how is that going to...

If you mean ALTER DATABASE to drop an LDF (can't drop the last one), then that should be in the default trace. If you mean an OS file delete, then...

No, that's not what I said.

The error message says that you are trying to either overwrite an *existing* database that is currently attached to the instance, or you're trying to...

From that message, the Prod1_Content database exists on the server and you're trying to overwrite it. Is that correct?

If that's not what you intend, double-check the database and file names.

erics44 (1/6/2016)

---

Lynn Pettis (1/6/2016)

---

One thing that would be nice is if Microsoft implemented CTEs more like the way Oracle implemented their sub-query refactoring clause. Oracle can treat the sub-query...

You can, but proportional fill will mean that the new file will get the bulk of new data. Trying to balance that out won't be trivial (rebuild all clustered indexes)

Hugo Kornelis (1/6/2016)

---

... in most scenarios.

If you have a database that has a very high amount of table allocations and deallocations, you can...

That would be my guess as well. Unlike SNAPSHOT isolation level, the READ_COMMITTED_SNAPSHOT setting changes how READ COMMITTED works, changing it to use row versions not locks. If it's turned...

THROW - Previous statement must be ; terminated...

On the same disk, none at all. On different disks, maybe. Are you seeing IO contention? If so, is the 'different disk' really different hardware? If yes to both, then...

And, for a sanity check, what does the following return?

SELECT DB_Name(27)

Odd. What was the exact statement you ran for checkDB and what was the complete output?

That wasn't what I asked.

Are you still getting the error after CheckDB ran?

I'm learning it at the moment. It's best for data analysis, data visualisation. I'd say anyone could find a use for it, even if 'just' an alternative to excel graphs.