Viewing 15 posts - 4,096 through 4,110 (of 9,244 total)
For sql server 2005 run the patch from the active node when you have an agreed period of downtime.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2013 at 9:39 am
Using -f implies the -m parameter so just use either\or.
To ensure that no applications connect and take the single connection I prefer the following startup command
[Code]Sqlservr -c -m"SQLCMD"[/code]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2013 at 12:27 am
sqlfriends (5/21/2013)
we have two nodes for the cluster. each cluster we installed two sql instances, one is prod, one is qa.
Does it mean we have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2013 at 3:18 pm
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
Viewing 15 posts - 4,096 through 4,110 (of 9,244 total)