Tag Info

New answers tagged

1

It is true that Availability Groups can make replicas of the active database and can support (depending on version) one or two readable replicas. This does not work with SQL Server 2008 R2 servers. But even if it did, this is not really the vehicle (yes, it is overkill) for getting a couple of databases to test with. Using the backups that you are already ...


0

Direct answer to your question What would be the best course of action to reduce the log file sizes? In full recovery model only transaction log backup, perhaps frequent transaction log backup in your case, would truncate the logs and keep check on log file size. There is no other way to truncate logs. I strongly suggest you to read Why transaction ...


1

In terms of wanting to get input from other people about their experiences, I can share about our use of Log Shipping in our Production environment. We use native Log Shipping and perform DR tests once a quarter for our critical systems. This involves failing over to the Secondary, pointing the application(s) at it, and testing that everything works as ...


0

I would suggest you to verify the service accounts you are using: SQL Server service account requires CONNECT permissions to partners’ endpoints Best option is to use domain accounts for all partners If using Local Service or Local System, must use certificate authentication. Ensure that the start date of the certificate is the current date or a day ...



Top 50 recent answers are included