Viewing 15 posts - 3,661 through 3,675 (of 9,253 total)
TheSQLGuru (1/23/2014)
Best practice for 2 nodes Always On is to use a File Share witness.
Mmm, that's not a BP that i've ever read in the AO documentation.
The quorum configuration...
January 24, 2014 at 3:54 am
PearlJammer1 (1/23/2014)
At first I changed the registry setting 'LoginMode' from 1 to 2 (HKEY LOCAL MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQL2012\MSSQLServer and I still could not log on with the sa account.
yes, a...
January 24, 2014 at 3:24 am
Akayisi (1/24/2014)
Koen Verbeeck (1/24/2014)
ALTER ROLE (Transact-SQL)The question is: why would you want to. The user is sysadmin so he/she can already do everything.
Hi Koen, the reason why i want to...
January 24, 2014 at 3:18 am
you might want to find out what is causing the log to blow in the first place 😉
January 23, 2014 at 9:01 am
well done
January 23, 2014 at 8:16 am
Joe.Spitler (1/23/2014)
January 23, 2014 at 8:03 am
the main point of confusion was that the OP was under the impression the cert was encrypted by password when in fact it wasnt, it's protected by the DMK. Had...
January 23, 2014 at 7:57 am
edit the volume in windows disk management, do you see a drive letter and a volume mount point name?
January 23, 2014 at 7:29 am
arrjay (1/23/2014)
Thanks for the link but it doesn't help me.The situation I'm in is that I have removed the certificates from server A.
The link does help...
January 23, 2014 at 7:14 am
arrjay (1/23/2014)
January 23, 2014 at 6:08 am
arrjay (1/23/2014)
Hi there - Not sure if this is meaningful;
First things first, edit your post and remove details of all other certs 😉
Leave just the detail on the cert...
January 23, 2014 at 5:41 am
arrjay (1/23/2014)
the certs exist on another server (which the db orginally came from), is there a way of scripting them out and copying them to the server?
Can you post the...
January 23, 2014 at 5:21 am
might be worth first attempting to get the cert from the other server, leave the master restore as last resort
January 23, 2014 at 5:13 am
If both servers are on the same site then using a disk witness would be fine
January 23, 2014 at 4:28 am
Do you not have a backup of the cert anywhere
January 23, 2014 at 4:25 am
Viewing 15 posts - 3,661 through 3,675 (of 9,253 total)