I have two IPs available to me, both are linked to the one VNN and they aren't the server IPs. As you know for multi-subnet AOs you can assign two...

My _DBA account is local admin on both nodes but not domain admin, I've been informed this isn't a requirement but could be wrong.

And the IP (well, two IPs really,...

• This reply was modified 2 years, 9 months ago by  zashah@gmail.com.

Hi Andreas

Thanks, the apps do have ApplicationIntent=ReadOnly in their connection strings and both Secondaries are set to Read-Intent Only. I also have the entry in SSMS when I test the...

Cheers, I tend to use good old revlogin for account migration but very valid point about the users not having their def dbs in place before restores. DBATools is excellent...

Thanks for your response. Yes, agreed less control when using Auto Seeding but I've found it to be very quick as uses the VDI stream.

I do have the 'luxury' of...

Hi

Thanks for the response. Log backups are hourly and usually take < 5 minutes to restore so not too bad.

Revisiting the databases on the system there are only two from...

^^^

Oh yeah, had already provisioned growing the TLOG to a reasonable size before running it in PROD, don't want the thing slowed to a crawl for slow file growth increments.

Thanks...

^^^

Thanks for the quick response.

The first run at it was wrapped in a txn just as a precaution in case of need to rollback but it never came to that...

Very handy script, thanks for your efforts.

Ali