The question was for database snapshots, not snapshot replication, but I can see where the confusion would lie. I have never heard a replication snapshot called a "snapshot of xxx...

You may be right, and it is better to have more than less. Given the cost, it might make sense just to go with 8GB.

However I've had plenty of corporate...

I think you'll have to have the SAN team dig in. A SAN network error, disk error, any number of things could have caused it. I'd have ignored it, but...

I think 8GB might not be a min, 4, or even 2 could work. It depends on what load you'll experience. What are the database sizes you expect, the workload,...

That gateway supports email, so sp_sendmail should work.

Don't do this from a trigger. Let the trigger drop data in a table and then use a job that checks the table...

I tend to agree with Paul. Adding columns to support different characteristics might be breaking a normal form and repeating data for no reason. It is also harder to search...

There's a default trace as well. Search that, it might have the info you need if you check it soon after the event.

We don't know what your XML looks like or the table. We don't know the data, and you didn't give the error.

Please provide more details.

Moved to XML forum

You pay a price with encryption. Are you sure that you need to encrypt dates?

Good points, Paul.

I like the idea of using a view to join the tables together if you need that.

Are you querying by month that often? I'm just wondering if...

You can create an indexed view, but it cannot contain a derived table (http://technet.microsoft.com/en-us/library/cc917715.aspx).

I'm not sure how you could create an indexed view here. You might want to create a...

And read Managing Transaction Logs[/url] by Gail

It was an error writing to disk. Is this a local drive? Any issue writing to disk usually causes the backup process to fail; it's why backups to non-local disks...

ITDPNDS

I'd compare prices on books for sure, as suggested, to see what the savings are.

The hassles of sharing, might not be worth it, but it is handy to be able...