Thanks a lot Jeffrey !.

Yes, [NT SERVICE\SQLSERVERAGENT] login is there in the instance, however it was disabled.

The job works even when this account is disabled as well.

However when I dropped...

Once the app team confirms that they are ready, as a first step, we DISABLE app login in SQL Server.
Then trigger a final log backup and get it restored...

Sometime ago we had an issue with DB restore in a new server, though it was working fine in old server.
That was problem with "Instant File Initialization", adding SQL...

As per my understanding, Primary DB will be accessible.
As it's ASYNCH, performance should also not hit.
LS Queue will get piled up. Log file will keep growing.
Once the...

Go ahead.
We have successfully migrated and configured AG for 20+ servers in last one month (SQL 2016).
Servers were in multiple subnets and we also configured multiple AGs on...

Hi,
I don't see any reason why it shouldn't work.
As long as primary and secondary replicas have same LSN, you should just be able to JOIN them in...

Hi,
Again, I am not a windows expert.
However it looks OK to me in fact.

1. The red...

What is windows version ?
Are you a local admin on the server ?

Mine is Windows 16.
I get "More Actions" in 2 places on the right...

Hi,
Don't right click and bring it online.
Instead, on the right hand side you have an option to
More Actions ==> Move More Cluster Resources ==> Select Node

Thanks Arsh.

We will need to restore system DBs including master as well is it ?.

Thanks again.

Thanks sgmunson
Hardware part is ok, that will be taken care of appropriately.

However I just wanted to know what are the steps to be followed, if we need...

Hi Michael,

Not sure about it. Recently took over the server Thanks.

Maddave (11/2/2015)

---

Not sure if this applies in you case, but SA also gives you mobility rights. If you have the VM running on one physical host and wish to move...

Thanks Anthony.