Viewing 15 posts - 1 through 15 (of 121 total)
andreas.kreuzberg - Friday, October 26, 2018 6:26 AMHi,
you should take a look on the page from ola hallengren
I agree 100%, I...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
October 27, 2018 at 12:46 am
I would check your quorum setup, it sounds like there weren't enough voting members to adequately vote to make the second site the primary. I typically recommend a file share...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
October 26, 2018 at 8:46 pm
One thing that happened to a client of mine is that their "Power Mode" in the host BIOS (was a Hyper-V VM) was set to balanced. If the server has...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
October 25, 2018 at 6:29 pm
Looks like it is running as the built-in service account. Did you give that account permissions in the instance to perform backups? It would also need permissions to whatever file...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
October 25, 2018 at 6:08 pm
ramyours2003 - Tuesday, October 23, 2018 11:09 AMIam having 3 ag groups .can I use same listner in this case
No, the listener...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
October 23, 2018 at 11:17 am
I also like to use the First Responder Kit from Brent Ozar. It's light weight and offers a wealth of information.
https://www.brentozar.com/first-aid/
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
October 23, 2018 at 10:40 am
The number of nodes doesn't matter for the listener, it sits on top of the Availability Group.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
October 23, 2018 at 10:36 am
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
June 10, 2018 at 4:55 pm
Thanks Jeff, I’ll give it a shot
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
June 7, 2018 at 10:42 pm
By the way, for anyone looking to do this, you just need to add the path to the solution to your shortcut Target path on the icon. Be sure to...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
July 21, 2017 at 3:11 pm
Exactly right, I've run into this before when requesting a new server from the infrastructure group...they always forget to add .net 3.5 and I always forget to check in advance.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
July 20, 2017 at 9:09 pm
All good info. Definitely use a file share witness, make sure that you have an AD service account running the SQL services before you get started and that it has...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
July 20, 2017 at 5:44 pm
As Sue suggested I believe you would need to install the component on server B then configure a new role for the service. I believe you can then add it...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
July 20, 2017 at 5:28 pm
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
July 11, 2017 at 9:16 am
Thanks for responding. Yeah, those are helpful to a point. I did some searching and found a cloud product called CloudMonix in the Marketplace that integrates into your Azure Portal...
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
July 3, 2017 at 2:04 pm
Viewing 15 posts - 1 through 15 (of 121 total)