Hi,

it depends, always on synchronized the complete database, and with a transactional replication, you are able to replicate the objects that you need to create your report.

If you use always...

Hi,

is there something in the ERRORLOG?

What about the HA endpoints, are they running, have all accounts the connect to endpoint permission?

Are there local firewalls, are you able to test the...

Hi,

are all accounts existing on both nodes?

Take a look in your ERRORLOG on each node.

Andreas

Hi,

I think, network is not the problem.

If we start the sql server on Server 1, and we create the computer logon for Server 1 on Server 2, and if we...

Hi Sue,

Ports are open, we checked this with powershell. In the ERRORLOG, nothing looks unusal.

And only one of the 2 nodes won't connect to the endpoint.

We don't know what we...

Hi,

if you like powershell, take a look at this page:

https://docs.dbatools.io/#Copy-DbaDatabase

Your are able to copy a single database to a new one, with one simple script.

Or do you need real time...

• This reply was modified 6 years, 5 months ago by andreas.kreuzberg.

Hi,

if your synchronized is a higher version of sql server, be sure, if you ever failover to the newer sql server, you never can back to the lower version. This...

Hi,

you can use logshipping to get a current database on the new sql server. If everything is synchron, you can stop logshiping and set the database on the new sql...

Hi,
please check, if IFI is active.
If not, the 15 GB  will be written with "0",
Kind regards,
Andreas

Hi,
you can change the cluster timeout via powershell. But, I think you may lost your microsoft support, if you change the default settings like timeout or  threshold of failover...

Hi,
it depends.
Single Nodes are offline if you are patching, no script needed.
And there are a lot of topic, how to patch an Cluster / AOAG.
AOAG, patch...

Hi,
it depends, if you use transactional replication, and you  add some new articel, like table or something like that, you hat to publish these new articel with the publisher to...

Hm,
are there some entries in the ERRORLOG, or a Screenshot from the error, if you try to bring the AOAG online again?
Did you try the t-sql on both...

Hi,
how do you realize a AOAG on a single node?
Do you use named instances?
How did you take your AOAG offline?
"Suspend Data Movement?

Are there some...

Hi,
take a look at transactional replication. There you are able to replicate a single table from a big database to a foreign location.
Kind regards,
Andreas