Viewing 15 posts - 2,326 through 2,340 (of 9,241 total)
muthyala_51 (2/26/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 9:40 am
to identify instance names to PIDs use either SQL server configuration manager or windows task manager.
In sql config manager the process id can be seen in the SQL Services window
For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 7:11 am
Anshul Parmar (2/26/2015)
I have given all permissions, still same issue.
Full permission to who??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 6:49 am
The error 3 indicates a lack of ntfs permissions on the file location.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:39 am
Is this a windows server failover cluster?
Are you using cluster shared volumes?
Can you provide more detail around this particular volume itself, I.e. How it was formatted, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:26 am
You'll need to supply more detail, is this a new instance youre installing or an existing instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:20 am
Are the nodes on separate geographical sites or are they both located in the same location. Since youre planning to use alwayson availability groups storage shouldnt be of any concern....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:17 am
a 2 node cluster will need a witness to attain quorum. If it's a same site cluster you could use a disk witness, if it's a cross site cluster use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2015 at 9:04 am
spaghettidba (2/24/2015)
Perry Whittle (2/24/2015)
do not evict the node, this is not the correct action.
Why wouldn't it work? I'm pretty sure I have done this in the past.
I'm not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2015 at 7:59 am
use a powershell job step instead and use the following
$checkdate = (get-date).AddDays(-30)
$checkpath = "C:\Program Files\MSSQL10_50.MSSQLSERVER\MSSQL\Log\*"
echo "The checkdate is "
echo $checkdate
get-childitem $checkpath -Include *.sqb | ?{$_.LastWriteTime -lt $checkdate} | remove-item
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 10:04 am
do not evict the node, this is not the correct action.
The restriction on how many nodes may host a clustered instance of SQL Server in Standard edition is within...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:48 am
you actually configured it to listen on 1433?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:40 am
after the recovery model switch you may run a differential backup and use this along with the existing full backup to initialise the new secondary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:36 am
not an error I've ever seen before.
Can you provide more detail on the cluster configuration, is this a new cluster or are you running the validation on an existing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:28 am
need to be looking in this catalog sys.dm_hadr_database_replica_states
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2015 at 7:31 am
Viewing 15 posts - 2,326 through 2,340 (of 9,241 total)