Viewing 15 posts - 2,056 through 2,070 (of 9,253 total)
When the alwayson availability group fails over the listener will be interrupted. It is a cluster resource and will be stopped on one node then started on another
June 9, 2015 at 5:32 am
TDE does not enable Table Data Encryption, it enables Transparent Database Encryption.
Do you understand what it does and why you would enable it would be my initial question?
June 9, 2015 at 5:29 am
this is something you'll need to cover with your licensing rep, if you install an instance on a passive node and leave it there it's no longer passive
June 5, 2015 at 10:02 am
BL0B_EATER (6/5/2015)
Or look into VB which we use in our little shop - IO.File.Delete(FileName).
Ooooh that's so yester year, here in the 21st century we use this 😉
$checkdate = (get-date).AddDays(-30)
$checkpath...
June 5, 2015 at 5:40 am
so what's your question?
June 5, 2015 at 5:35 am
just use Powershell, it's much easier
June 4, 2015 at 11:32 am
Database admin(DBA) (6/3/2015)
June 4, 2015 at 5:09 am
it's not a bug it's by design and yes, there is a trace flag to force the engine to behave as sql server 2008 R2. The trace flag is 272,...
June 3, 2015 at 8:36 am
Arestas (6/3/2015)
Know any documentation about this?Regards,
Arestas
In response to the modification of resources this link states
MSDN
For example:
?Do not change any availability...
June 3, 2015 at 7:11 am
Dan121 (6/2/2015)
I know RDP on Prod server is bad which take lots of resources
Erm, no, actually no it doesn't. And just because someone can RDP to the server it doesn't...
June 3, 2015 at 6:07 am
Arestas (6/3/2015)
I tough on associating a virtual ip to the AllwaysON cluster resource
That's exactly how you'll need to do this, a shared IP address will be needed. FCIs have...
June 3, 2015 at 5:57 am
a further limitation of TDE is the effect on compression, this can be an issue for those who wish to use effective compression in their backups, Things have got better...
June 3, 2015 at 5:03 am
JeepHound (6/2/2015)
what load are you expecting to be placed on the systems?
JeepHound (6/2/2015)
June 2, 2015 at 9:16 am
Inst1 and 2 are in the same mirror group
Inst3 and 4 are in the same mirror group
That is perfectly valid, what you couldn't have is Inst 1, 2 and 4...
June 2, 2015 at 8:11 am
open explorer and find the data folder then right click and select properties. On the security tab you'll see details of permissions applied
May 29, 2015 at 8:16 am
Viewing 15 posts - 2,056 through 2,070 (of 9,253 total)