The "log" is a misnomer, IMHO. It's more of a change tracking file for the db than a log.

You shouldn't, in general, read the log. Especially now with auditing...

I tend to agree. It seems that every game is making up for the previous ones. The officials seem to go back and forth between giving calls to the Celtics...

I can see a GUID clustered if it's built on NewSequentialID() only.

My pleasure, and good luck here. Not sure if I'd use the CTE for future versions here. If you are using it a lot, then it might be nice as...

1. The performance hit for GUIDs is the size, and the fact that if this is clustered, you can create lots of page splits. I tend to agree with you....

You don't put the variable in the view. You'd have:

CREATE VIEW tAdjustmentEx

as

SELECT

A.Id, D.AdjustmentHeaderId, A.AdjustmentDetailId,

D.TypeCode, A.MeasurementId, A.Value, A.Row

FROM tAdjustment AS A

INNER JOIN tAdjustmentDetail AS D

ON A.AdjustmentDetailId=D.Id

And then...

Short answer: you can't turn off the log. That's part of how ACID principles are maintained and you have an intact database system, with the log.

So with that being the...

I think you need to drop and recreate the login if it did not transfer. Did the SQL Server host get moved OK? Is the service account set to a...

You could use something like bitlocker on Windows to encrypt the data, but other than a third party, there's no way to encrypt a SQL Server backup natively.

A view would work. The WITH indicates a CTE, which is essentially a materialized view for that query.

You could use a derived table as well, however I think it's...

Backups used to be called dumps in SQL Server. As mentioned above, it's a backup.

No, You can add a password, but the files are not encrypted and can be read with a text editor.

I think that the sports fans do fine when they're separated. It seems when they're in the same physical location we have issues.

It is interesting to see how excited people...

Are the backups going through an Agent on Commvault? Or are these disk files being pulled to tape only?

I would certainly check with CommVault and be sure that you don't...

If they are clustered resources, then as George mentioned, they'll fail over. Is the backup drive 1 from Node 1 visible on Node2? It should be.