Viewing 15 posts - 1,576 through 1,590 (of 9,244 total)
ramyours2003 (11/12/2015)
can any one help on the dmv's how to check and trouble shoot the issues in always on group in sql ?
what's wrong with the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2015 at 4:25 am
David Rich (11/12/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2015 at 4:22 am
krypto69 (11/12/2015)
then right click and 'suspend data movement' on all the DB's.
Just suspend data movement on the primary and that will be enough
krypto69 (11/12/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2015 at 4:07 am
alnoor (11/9/2015)
Hi GuysWhats the best way to stop/pause sql services on a cluster for maintenance.
failover should not happen.
Thanks
Stop the clustered SQL Server resource using powershell
stop-clusterresource "sql resourcename"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2015 at 4:41 pm
Raghavender (11/9/2015)
Yes Even service accounts are added into admin group and we have given full control on the folder and files.
adding an account to the local admins does not guarantee...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2015 at 4:38 pm
MadAdmin (11/10/2015)
MS cannot remove mirroring unless they have a version of HA which will replace Mirroring.
Yep, it's called Basic Availability groups in SQL Server 2016
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2015 at 4:29 pm
744 (11/5/2015)
Hi,we needed to change the ports on the 3 named instances because of firewall rules.
choose a free port for each instance from the upper port range and open the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 9, 2015 at 10:58 am
mark.williams 37494 (11/6/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 7:54 am
tcronin 95651 (11/5/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 7:37 am
stop the sql server service and delete the tempdb files and then restart the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 7:35 am
mark.williams 37494 (11/6/2015)
PretendDBA (11/6/2015)
Have you done testing?
Yes i have carried out testing and have encountered the following behaviour, can anyone tell me if this is expected behaviour.
If i stop the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 7:28 am
GilaMonster (11/3/2015)
While that's the ideal, in many cases multiple services...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 7:08 am
tress (11/4/2015)
That's what I have decided to do, is it possible to script the passwords in anyway, unfortunately many of the accounts were created before my time and nobody...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 7:06 am
SQLBill (11/4/2015)
Background:
Primary server
Two Replicas
We...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 7:02 am
Raghavender (11/6/2015)
I am trying to attach a database. But I am receiving below error:
Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".
I have added...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2015 at 5:36 am
Viewing 15 posts - 1,576 through 1,590 (of 9,244 total)