Viewing 15 posts - 4,096 through 4,110 (of 9,241 total)
I use a logon trigger to acheive this, blocking an AD group accessing via certain applications, but the trigger could quite easily just block the group.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2013 at 11:37 am
you have 2 adapters connected to the same network range, is teaming an option. You should have at least one adapter connected to a separate heartbeat network.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2013 at 9:18 am
If you really want to do it like you detailed then ensuring the same patch level is essential, however you will definitely have issues with encryption using the SMK which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2013 at 9:11 am
To mirror in a workgroup can be acheived with minimal effort using this post.
However, it's a little more complex, but the best way is to use certificates as detailed here.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2013 at 8:51 am
Rather than virtualise the existing server, just deploy and configure a new VM, retrieve your existing backups from the old server. You'll also need to script out any objects such...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2013 at 5:58 am
arun.zakaria (5/23/2013)
So currently the failover is disabled
How have you disabled failover?
arun.zakaria (5/23/2013)[hrand we are trying to unistall the cluster. However the drop down does not show anything.
You're running the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2013 at 3:14 am
arun.zakaria (5/22/2013)
We have two SQL servers configured as a failover cluster. One of them is a physical and the other is a VM.
Perfectly reasonable I don't see any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2013 at 4:54 pm
kevaburg (5/17/2013)
Of course, in order to do this you Need to be using the Enterprise Version of the Software.....
On a slightly different plain to my article as this is moving...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2013 at 11:12 pm
kevaburg (5/17/2013)
Better to do a backup and restore.....
Hmm, no, as my article shows the best and supported way to move your data files is to use the alter database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2013 at 11:09 pm
You would more likely use a certificate for your column encryption.
What Gail is saying is that someone who is sysadmin on another instance could take the backup and the cert...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2013 at 11:14 pm
good work, let us know how you get on
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2013 at 7:58 am
which files are not being deleted the files on the primary or the secondary?
Results of the following please
Against the primary instance note the value for "backup_retention_period"
exec master.sys.sp_help_log_shipping_primary_database @database = 'yourprimarydb'
Against...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2013 at 7:06 am
This guide was written sometime ago and the software may well have changed since then. Check the Freenas docs or alternatively you could use a Windows 2008 VM with Starwinds...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2013 at 5:26 am
ginolard (5/12/2013)
1 NIC each only for Public, iSCSI and Heartbeat connections (no more NIC Teaming)
Under Windows 2008, teaming is fully supported for the public network and the Heartbeat network, never...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2013 at 5:19 am
Russell101 (5/12/2013)
So if I have the primary and witness servers at our main location and we suffer a power outage will the secondary server automatically takeover?
No, more detail on failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2013 at 6:45 am
Viewing 15 posts - 4,096 through 4,110 (of 9,241 total)