If the remote database can be read only log shipping would be your best solution

Michael Gerholdt (12/20/2016)

---

Initially, AlwaysOn Availability group works from everywhere with clients of various sorts aimed at listener.

Do a manual failover, and now only clients on the same VLAN as the...

Cluster Shared Volumes are a feature of Windows Server and integrate with Windows Server Failover Clusters, hence their name of Cluster Shared Volumes.

They were originally employed to provide storage configurations...

This thread is over 2 years old!!

Pre size your log and don't shrink it

elulu2000 (12/15/2016)

---

I have a SQL database that must be always on 'standby' mode because I must restore transaction logs from a vendor database to my local database on stand by...

praveen_vejandla (12/15/2016)

---

Hi,

In case of multiple AG secondary replicas, can a database be safely removed from only one of the secondary replica without any impact on other replicas?

I don't want to...

Don't shrink your log files, apart from the fact it will very likely introduce massive file system fragmentation it's also very bad for perfomance.

Each time the log is grown the...

BradGrantSky (12/15/2016)

---

Hi

AD user names have changed. Just the naming standard has changed not the domain.

eg

Previous Name : ROCK\JDaniels

New Name : ROCK\AA230373

On SQL Server, there has been no issues.

There is...

Clint-525719 (12/12/2016)

---

For SQL Server, yes. For Windows, the team responsible told me that each VM needed its own license. I am going off of what they are telling...

Siberian Khatru (12/14/2016)

---

but in order to change the certificate on a database -- don't I need to un-encrypt it and then re-encrypt it with the new certificate? Or is...

krypto69 (12/8/2016)

---

Hi,

I am backing up the transaction log via a maintenance plan every 15 minutes on my secondary high avail server.

It works and creates trn files every 15 minutes.

My...

shadow66 (12/13/2016)

---

We are planning to migrate an existing AG (2-node AG cluster, no shared storage)

to a new SAN, and want to keep the same drive letters, say F and...

Ok, so this will change with a failover as the Primary obviously changes.

Ok this...

You're obviously missing some log backups.

What is the current config for your Ag backups?

Secondary?

Primary?

Any Replica?

Are the backup files being stored centrally?

When the primary changes the backup location, if local, will...