(I'm a bit bored having to work a Saturday for a datacentre migration-don't let me egg you on too much :).)

I don't think you can while it's in the AG- just remove it, go on :-D.

And your transaction log might be growing really big as a result too, so don't leave it any longer than you have to.

Since it's not working anyway, why not try removing and re-adding it to the AG first, and if that doesn't work, taking it offline and bringing it back online. Worst...

Oh, sorry- how annoying. What about removing the database from the AG then adding it back? Sorry if I'm stating the obvious.

Have you tried just resuming the data movement instead?

Would an alias work for your purposes?

https://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/

Hi- see the other responses.

Ah, damnit, I thought I'd try to give the benefit of the doubt, but it's more homework.

HI there, and welcome. Could you attach your files another way? Most people won't click on an unknown zip file, especially not from work. It could be a sacking offence...

How are your users accessing the database- through an application? I think it would be easier for you to set up read-only routing for those users, and use "application intent...

I bet loads of people at the bottom of the list will miss out as a result.

BLOB EATER (1/11/2017)

---

rodjkidd (1/11/2017)

---

The SQLBits public session voting is open. A few familiar Threadizen names on there.

Just a pity you can only pick 10 🙁

So if you haven't done so...

BrainDonor (1/10/2017)

---

Jeff Moden (1/9/2017)

---

I used to think it odd that people that people I've interviewed with more than 5 years of "experience" with SQL Server that made the claim of...

Thanks. I'd love to know more about that. (I did Google it, but I'm not finding anything meaningful because the keywords are so popular).