Viewing 15 posts - 151 through 165 (of 1,318 total)
Out of interest, can you add the listener after you've created the AG?
January 8, 2019 at 3:38 am
When you try to connect to the listener, what happens (is there an error message, etc.)?
January 7, 2019 at 4:57 am
Port 1433 should work ok for the listener; have you tried it?
January 7, 2019 at 2:42 am
I'm not sure that's strictly an in-place downgrade- isn't it just an uninstall and reinstall in disguise :)?
December 10, 2018 at 8:41 am
December 6, 2018 at 1:31 am
You don't say what you're upgrading from and to, but don't do an in-place upgrade in Production without at least testing it elsewhere first. (In fact I'd say don't do...
December 3, 2018 at 5:05 am
Unless I've misunderstood, I think the term you're looking for is a multi-subnet failover cluster?
November 29, 2018 at 8:38 am
SQL services for SQL01\int01 was stopped and failover occurred,
hence SQL01 becomes primary and SQL02 is...
November 27, 2018 at 6:31 am
It would be prudent to do some testing first because of the new cardinality estimator that came in in 2014.
November 14, 2018 at 6:05 am
My inlaws really, really don't get it, and my father persists in thinking that I work in InfoSec, even though I never have, so it's quite hard-going round my way
November 5, 2018 at 7:15 am
I haven't tried it, but I assume it's because backups taken on secondary replicas have to be copy-only.
Why do you need to make primary the preferred backup location...
November 5, 2018 at 4:38 am
November 2, 2018 at 10:21 am
I don't want to switch to another one, so maybe I'd apply for something totally different. I don't know, National Park Ranger. (Obviously that would pay a lot less.)
November 2, 2018 at 3:29 am
Try switching to the master database and then running the restore code again. Or you could do alter database NAME set restricted_user with rollback immediate first, then try again.
October 31, 2018 at 3:41 am
I have many questions!
- Are you restoring the database yourself each day, or is somebody doing it for you?
- Has the restore definitely finished when you go...
October 31, 2018 at 2:32 am
Viewing 15 posts - 151 through 165 (of 1,318 total)