If you are going to provide SQL Server support, you should probably know what you are doing.
So the other day I got a ticket opened by my companies Managed Service Provider. There was a backup failure on one of our databases. The response from the hosting provider was: This failed due to a “Error: 3041, Severity: 16, State: 1.” error. This is because you must perform a full database backup before […]
Cloud and the law
Moving data into the cloud is a huge thing with Microsoft and Amazon (among others). However for those in countries that aren’t the US there are some major road blocks to putting your data into the cloud. The first issue is that when the cloud provider is a US company (which most of them are […]
Happy New Year
Happy new year to everyone. May all your data storage, and query tuning dreams come true in 2011. Denny
We are currently running on an EMC SAN. Did I hear you correctly, we should have databases, backups, temp, and logs on the same LUN? Thanks.
No, you want to put them on different LUNs. IBM is currently recommending that on the XIV array that everything can be put on a single LUN as the LUN is spread over all the disks in the array. For an EMC array you’ll want to have separate LUNs for each. Denny