Viewing 15 posts - 196 through 210 (of 1,318 total)
Have you taken any backups since changing the recovery model?
August 31, 2018 at 7:51 am
That's not just a little shady, it's downright wrong.
August 31, 2018 at 5:17 am
I found Brent Ozar's blog invaluable when I was starting out (actually, I still do). They used to offer a 6 month DBA training plan pdf that was very helpful....
August 31, 2018 at 4:33 am
Should there be more files? Please give us the exact steps you are following when you get that error message. Are you restoring/attaching/doing something else?
August 28, 2018 at 5:43 am
You haven't got any antivirus scans running, have you? .baks would usually be excluded but it's worth checking.
August 28, 2018 at 4:54 am
I ask our Windows team for that; it depends how things operate where you work.
August 23, 2018 at 8:38 am
The folder used for data synchronisation can be on either of the servers, yes. You don't need a third one.
For the service account you would ideally use a...
August 23, 2018 at 3:24 am
August 21, 2018 at 5:30 am
There isn't a fixed number because it depends on what resources you have available.This is a good article about it: https://www.red-gate.com/simple-talk/sql/database-administration/alwayson-availability-groups-what-not-to-do-when-adding-databases/
August 21, 2018 at 2:04 am
It could still be a Kerberos issue. Are you using the same account across all the servers? (I warn you now, my SSIS skills suck so I might not get...
August 20, 2018 at 5:30 am
I always use a gMSA for my SQL instances even if they're stand-alone because if it turns out we want to add them to a cluster later on it's much...
August 17, 2018 at 8:28 am
We don't do it here (a fairly large estate) even though it sounds like a good idea, because we grant access to certain specific file systems to our gMSAs, and...
August 17, 2018 at 8:20 am
You could run them all under the same gMSA. I wouldn't do it myself because I like to have distinct accounts for each instance (or group of instances where Availability...
August 17, 2018 at 6:37 am
August 17, 2018 at 6:25 am
Viewing 15 posts - 196 through 210 (of 1,318 total)