Viewing 15 posts - 5,551 through 5,565 (of 9,241 total)
derekr 43208 (5/21/2012)
For AG's, all nodes must be part of the same cluster but with seperate storage?
For HA Instances all nodes must be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2012 at 5:02 am
This is already detailed in my previous replies, but
derekr 43208 (5/21/2012)
does each node need to be part of the same cluster?
For availability groups, yes, all nodes need to be part...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2012 at 4:36 am
This seems to have veered drastically from your original request. Your production servers are virtual machines are they?
You could start by answering my questions and reading the link I posted...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2012 at 1:07 pm
madhu-686862 (5/16/2012)
How to use SQLIO for Mount points on cluster to test the IO on SAN?
Have you read the documentation for SQLIO? Also check the SQL server storage best practices...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2012 at 12:28 pm
deep_kkumar (5/16/2012)
1) How much space I need to allocate for quorum drive?
512MB
deep_kkumar (5/16/2012)
2) shared disk space depends on the database sizes.
How much do you think you will need??
Will you be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2012 at 12:12 pm
Sure, here you go
SELECT 'CREATE LOGIN ' + name +
' WITH PASSWORD = ' + sys.fn_varbintohexstr(password_hash) +
' HASHED, SID = ' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2012 at 5:25 am
Norm-677551 (5/14/2012)
from?.dbo.sysfiles a
) x
where [free_space_mb]/[file_size_mb]*100>50
and NAME like ''wslogdb70_%'''
...
Am I right?
if you're going to use system catalogs at least use the right one. For file info at database level...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 2:30 pm
erm, how about the Microsoft website 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 1:54 pm
Automatic failover is only possible with a witness and high safety mode.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 1:43 pm
capn.hector (5/14/2012)
we fixed it by detaching the database with sp_detach_db rename the log file then sp_attach_single_file_db. it worked and we can now shrink the file.
Bad idea generally.
A quick check...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 11:49 am
AK1516 (5/14/2012)
I have no differential backups running.
You may not be able to run differentials all week, but you may get away with running 2 full backups per week and differentials...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 11:08 am
with replication you have a manual failover action, depending upon your mirror session type this will also be either manual or automatic failover. For sessions using a witness you may...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 10:29 am
AK1516 (5/14/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 10:25 am
why not just use the system function fn_varbintohexstr()
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2012 at 4:40 am
Yes, fail over cluster instances may participate as an availability replica in AlwaysOn availability groups. Think of it like this
You have a WSFC comprising of 3 nodes. You have a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2012 at 12:18 pm
Viewing 15 posts - 5,551 through 5,565 (of 9,241 total)