Viewing 15 posts - 451 through 465 (of 1,318 total)
March 17, 2017 at 8:29 am
March 17, 2017 at 3:25 am
What is the log_reuse_wait desc for that database (in sys.databases)?
March 16, 2017 at 8:59 am
Sorry, I meant to say "have you recreated your endpoints", not checked. I saw you'd said you had already.
So you have Availability Groups in which some databases are replicating...
March 16, 2017 at 8:35 am
March 16, 2017 at 8:30 am
Do the databases succeed and fail on an AG basis or an individual database basis? Have you checked all the endpoints?
March 16, 2017 at 8:19 am
In other news, does anybody know a workaround to the issue of not being able to query otherFacsimileTelephoneNumber from AD through a linked server in SQL Server? I can get...
March 15, 2017 at 8:14 am
I came out of that interview raging and absolutely incredulous, but it gave me a good story to tell at the interview I had that afternoon, and I got that job,...
March 15, 2017 at 7:20 am
March 15, 2017 at 4:45 am
I can't log on at the moment to check my setup, but there are a couple of things you can check if you haven't already.
Run this script on the primary...
March 13, 2017 at 10:09 am
I like this rule: https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/
In your case, assuming there's only one instance on the server and nothing much else is running on there, about 26 GB.
March 13, 2017 at 5:37 am
We have it running in an AG setup right now. I'm not trying to teach you to suck eggs, but is your application connection string definitely pointing to the listener?...
March 10, 2017 at 9:18 am
I did select BAK file to restore, just transaction log backups are being shown in UI for some reason
What happens when you remove the .trn files and try...
March 10, 2017 at 7:01 am
It means you can take backups on your secondary (read-only) replica instead of on the primary (read-write).
March 10, 2017 at 6:56 am
Ah, those idealistic early days!
March 9, 2017 at 7:40 am
Viewing 15 posts - 451 through 465 (of 1,318 total)