Viewing 15 posts - 2,011 through 2,025 (of 9,241 total)
antonio.estima 4150 (6/18/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 8:34 am
thank you Johan for the correction 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 8:32 am
the log shipping backup job should be taking log backups and not full backups. Check the job step history and post here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 4:57 am
answered here http://www.sqlservercentral.com/Forums/Topic1695309-3411-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 4:55 am
so what have you done about cluster disk 1 and cluster disk 2?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 4:51 am
SQL!$@w$0ME (6/17/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 4:40 am
alex_pixley (6/17/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 4:09 am
To do the same in powershell only requires a few lines of code 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 1:06 am
simon.harvey 41170 (6/16/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 16, 2015 at 4:05 am
Try these, no gaps
-dE:\DATA\master.mdf
-eE:\log\ERRORLOG
-lE:\DATA\mastlog.ldf
-T272
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 16, 2015 at 3:58 am
please post the results of the following powershell query
Get-ClusterResource | FL name,state,resourcetype,ownergroup,restartthreshold,restartdelay,restartperiod
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 16, 2015 at 3:54 am
the problem is not with the SMK the problem is with a DMK
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 16, 2015 at 3:29 am
hari.devadas 4119 (6/15/2015)
Yes, this would essentially P2V a single node cluster.my question would that work ?
No!!!
You're still not providing a definitive answer to my questions.
Do you want to end up...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 9:13 am
hari.devadas 4119 (6/12/2015)
Easy way to do this suggested by some was evicting the unwanted node
This will leave you with a single node cluster
hari.devadas 4119 (6/12/2015)
remove the cluster service
To remove clustering...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 8:43 am
Check the following
USE master
SELECT name FROM sys.symmetric_keys WHERE name LIKE '%DatabaseMasterKey%'
Assuming a DMK exists what password was used, check the encrypted state using this too
SELECT CASE is_master_key_encrypted_by_server
WHEN 0 THEN...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 8:37 am
Viewing 15 posts - 2,011 through 2,025 (of 9,241 total)