Viewing 15 posts - 3,406 through 3,420 (of 9,241 total)
adeel.imtiaz (3/30/2014)
Do we need a Shared Storage(SAN) for SQL Server 2012 AlwaysOn
No, not for a standard AlwaysOn configuration involving replicas that are standalone installs of SQL Server
adeel.imtiaz (3/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2014 at 4:08 am
chewychewy (3/29/2014)
I have virtualbox installed on my notebook.
For testing purpose, is it possible to setup SQL Server Fail-Over cluster using virtual box?
I don't have a shared storage. How can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2014 at 5:29 am
deepak.bisht (3/21/2014)
One of my user database is somehow moved to "System Databases" container in SQL Server Management Studio(I don't know how it moved).
i.e. it is visible in Enterprise...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2014 at 9:14 am
Eric Mamet (3/27/2014)
This database contains mostly one BIG...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2014 at 9:03 am
sql-lover (3/28/2014)
Perry Whittle (3/28/2014)
sql-lover (3/27/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2014 at 8:36 am
GordonLiddy (3/28/2014)
with the primary configured for Read/write.
This means that connections with the application intent set to ReadOnly will not be granted in the Primary role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2014 at 8:32 am
The default behaviour for an identity column now is to increase the seed after a restart or failover, etc. By doing this
sql-lover (3/27/2014)
I fixed it via DBCC command
you are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2014 at 7:21 am
GordonLiddy (3/28/2014)
Hi there!What happens when an automatic failover occurs, in a two server AlwaysOn Availability Group configuration where the secondary replica is configured as read-only?
If both replicas are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2014 at 6:42 am
lisafox.it (3/27/2014)
Observation - The virtual hostname is registered in DNS and it is resolving without any problem.
What command are you using to test the name resolution?
lisafox.it (3/27/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2014 at 6:34 am
chewychewy (3/26/2014)
Hi Guys,I'm quite confused and need your advise.
Understand that for AlwaysOn, we have 2 options:
1. AlwaysOn Failover Cluster Instances
2. AlwaysOn Availability Groups
For no 1 its more of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2014 at 7:55 am
Essentially the databases DB1,DB2,DB3,DB4,DB5 would be primary on Server A in an AlwaysOn group with secondary as Server B
The databases DB6,DB7,DB8,DB9,DB10 would be Primary on Server B with secondary as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2014 at 7:23 am
chewychewy (3/27/2014)
When in ASYNC mode, the primary replica commits transactions without waiting for acknowledgement that an asynchronous-commit secondary replica has hardened the log. Asynchronous-commit mode minimizes transaction latency on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2014 at 6:25 am
chewychewy (3/27/2014)
Need your advise here.
Anyone did such setup with AlwaysOn Avail Group?
We are looking into using AlwaysOn Avail Group for the purpose of HA.
Server A: Instance A with (DB1,DB2,DB3,DB4,DB5)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2014 at 6:06 am
cesarscorp2 (3/26/2014)
Thanks for the recomendation but I checked these options but the problem persist.I think the problem is about the service account but I don't know What is the account?
first...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2014 at 4:13 am
You remove just the SP via add/remove programs it rollback for you. The backups are for if anything goes bang! !
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 25, 2014 at 10:36 am
Viewing 15 posts - 3,406 through 3,420 (of 9,241 total)