Viewing 15 posts - 1,876 through 1,890 (of 9,241 total)
Database admin(DBA) (7/21/2015)
Yes the account have full sysadmin permissions
Which account
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2015 at 3:17 am
see your question here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2015 at 10:14 am
firstly check the windows firewall on both nodes.
rcaballero (7/21/2015)
But when I issue the ALTER DB SET PARTNER command
what commands did you use to create the database mirroring endpoints on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2015 at 10:05 am
Database admin(DBA) (7/21/2015)
Database Mirroring login attempt by user 'xxx\xxxSQL.(Domain account i.e,SQL server account running on this account)' failed with error: 'Connection handshake failed. The login 'xxx\xxxSQL' does not have CONNECT...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2015 at 9:52 am
mailtoashokberwal (7/20/2015)
I have a tableA in some DB on transaction server (Enterprise Edition), this table is being...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2015 at 9:20 am
Database admin(DBA) (7/21/2015)
Now suddenly the database status showing as principal server (Principal, Disconnected) and Mirror server (Mirror, Disconnected, In recovery).
Have you checked the logs, do you see any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2015 at 8:07 am
Please return details of the following Powershell query
Get-ClusterQuorum | ft Cluster, QuorumResource, QuorumType
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2015 at 5:27 am
Windows 2003 used to require a restart of the clustered sql server resource when adding a disk as a dependency, Windows 2008 onwards doesnt
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2015 at 9:28 am
are you using alwayson availability groups or failover cluster instances or even both?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2015 at 9:26 am
are you using Alwayson availability groups?
Are you attempting to backup the log on a secondary database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2015 at 9:24 am
Yuri55 (7/16/2015)
On the second thought- this problem (2-nd instance should follow 1-st one after failover to another node) looks a bit confusing to me now. I mean main reason...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2015 at 7:01 am
DBA on Route (7/17/2015)
Short version: Learning.
Ok, its ideal for that
DBA on Route (7/17/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2015 at 6:56 am
DBA on Route (7/17/2015)
I'm a DBA in training and this is my second post here on SQL Server Central.
--========================================================
Sadly I don't have a spare server to mess about with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2015 at 6:54 am
Joy Smith San (7/15/2015)
As per https://technet.microsoft.com/en-us/library/ms187798(v=sql.105).aspx] , expiration is not enforced when the certificate is used for encryption.
Yes, that is correct an expired cert will not hinder the backup restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2015 at 3:52 am
Yuri55 (7/14/2015)
What I am looking for- how to configure cluster (e.g. via quorum, etc) to force both instances failed together?
Quorum does not provide what you are seeking, quorum is an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 11:20 pm
Viewing 15 posts - 1,876 through 1,890 (of 9,241 total)