3
votes
Simplest way to shrink transaction log files on a mirrored production database
This is an older question, but there are some things that were not explained well and this will hopefully shed some light. The how to shrink was answered, mostly, but this will explain the "why" part ...
- 186
3
votes
What carries out SQL Server Mirroring?
SQL Server Mirroring is part of the core engine. When you setup mirroring, SQL Server enables a TCP endpoint to support the flow of log records from the primary server to the secondary server, and to ...
- 185
2
votes
Accepted
Error configuring witness server for failover in SQL Server
You've created an ENDPOINT on the witness, right?
Read this on how to create a witness endpoint.
Check that there isn't either the Windows firewall or a network device blocking the endpoint port on ...
- 10.8k
1
vote
Accepted
Database server vs NAS for data files
I depends on what software you're dealing with but...
Usually (historically speaking) you would not want to put database storage on a NAS, because that would mean using a network filesystem like NFS ...
- 6,210
1
vote
Migrating from normal RDS to Encrypted RDS
Probably too late, but, I would suggest spinning up a new 10xl unecrypted RDS from a snapshot, and then create a new blank 10xl encrypted RDS. These faster RDSs will hopefully speed it up. After you ...
- 11
1
vote
Accepted
SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes
Your intuition is likely correct. You can verify that the SIDs are different between your nodes by running:
select name, sid from sys.server_principals
on each node and comparing them.
As far as ...
- 3,004
1
vote
Accepted
What are the best practices to mirror a web app?
As you describe your application, I am afraid it will not be very easy to 'mirror'. Especially if the data has to change in real time (as it does with GDocs).
I am afraid MySQL is not a very good ...
- 3,927
Only top scored, non community-wiki answers of a minimum length are eligible