12am full to 2am diff is 26 hours for the first one, so no, not 24 hours.

In terms of your last question, changing logins makes changes in master. Changing users...

This help? Low memory? https://dba.stackexchange.com/questions/141236/failed-allocate-pages-fail-page-allocation-1

A few other links point to this.

It's such a wide platform now, I constantly find things that I've either forgotten were added, or never knew because of the changes.

Definitely an exciting time to work with data,...

You'd be wrong. You can change the data type of an identity property column to one of the types in the error. What you cannot do is remove the identity...

It can be a weird line here.

...

Now, is that being a hero, or just helping out where it was pretty obvious that help was needed? I could see arguments...

To be a "hero" means to never be able to take a proper vacation. Even if you're lucky enough to be granted permission to leave, there's always the risk...

This is one of the few places I have worked where that cannot happen (as stated) because all work is done by release.

The release dates are scheduled before that...

There is nothing "heroic" about establishing yourself as a lynchpin, keeping your co-workers in the dark about how things work, and then bailing one day for a better job.

Of...

You've got different configs or permissions in the instances. That's where things aren't working. I'm guessing the top one has some permissions on public revoked

Culture is the hardest part to change in DevOps, which is people. Process is hard, but getting people to question how they do things and adapt to what others do,...

What does myLogin look like as a login?

You're describing things, but many of us have seen for years, that descriptions can be incomplete, and you might do something, or have...

You'll need to show some code or better explain what's happened. My guess is you haven't created the login with the same permissions.

You'll need to show some code or better explain what's happened. My guess is you haven't created the login with the same permissions.

We're upgraded. ssc-db-1 and 2 are decommissioned and 3/4 are live. Here's 3

https://monitor.red-gate.com/overviews/SQLMON-EC2-BM2/dbms/r1,4%3Abase,s36%3A260ca7e9-c6fa-4cc5-8de2-e05e68114e71,7%3ACluster,1,4%3AName,s21%3Assc-db-clus.ssc.local,9%3ASqlServer,1,4%3AName,s10%3Assc-db-n3%5C,?zoom=1698946515629%2C1698953715629&present=true

I had nothing to do with this. AFAIK, this was a simple backup/restore, with norecovery and then...

I, too, am still disappointing in replication. It's far too brittle in many cases, and the tooling hasn't evolved enough to make it easier and better for admins to deal...