Viewing 15 posts - 3,181 through 3,195 (of 9,244 total)
To move master you'll also need to move the resource database too. Move master using the following
edit the SQL server service and change the paths for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 3:09 am
go onto the remote server and find the backups share. You need to check and set Share permissions then move to the folders security tab and set NTS ACLs too.
The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 2:50 am
gwellbrock (7/10/2014)
The load of the databases require 3 active servers.
Do you mean you distribute the databases between 3 separate SQL server instances?
gwellbrock (7/10/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2014 at 2:48 am
david 81886 (7/9/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2014 at 4:37 pm
david 81886 (7/8/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2014 at 2:06 pm
Richard Bates (7/7/2014)
Just out of interest, why would it be best to install the oldest instance version first?
It was really only an issue with systems that had sql server 2000...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2014 at 9:03 am
ramyours2003 (7/5/2014)
how to install active\active cluster in sql2008?
The same way you normally install a clustered instance. Active\Active is no longer used by Microsoft, multi instance clusters can run all on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2014 at 8:42 am
Richard Bates (7/7/2014)
Hello,We have a three node 2012 enterprise cluster currently running several 2012 instances.
Is it recommended to run a 2008 R2 instance in the same cluster?
Thanks.
R.
Yes you can have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2014 at 8:36 am
Lempster (7/3/2014)
Where do you get these nuggets of information from Gail? 🙂
Paul Randal 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2014 at 8:50 am
faisalfarouqi (7/3/2014)
Do you have a script to check if it's primary or secondary? Could you pls. post it in case if you have one.Regards,
Faisal
This will pull the Primary replica for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2014 at 9:07 am
Neeraj Dwivedi (7/2/2014)
Keep in mind that that you have to restore DB with No Recovery option on DR site.
Or standby\readonly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2014 at 6:44 am
sounds like the secondary is not set read only, check this and post back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2014 at 6:41 am
The listener cannot actually be stopped or started, it can be deleted or restarted. If you stop the IP or VNN cluster resources you'll take the AlwaysOn group offline so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 3, 2014 at 4:41 am
GilaMonster (7/1/2014)
First check the throughput of the backup device. Backups are IO-bound operations, if either the source (drive with the data files) or destination (drive...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2014 at 5:07 am
RD Francis (6/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2014 at 4:51 am
Viewing 15 posts - 3,181 through 3,195 (of 9,244 total)