Not to scare you, but "Could not redo log record" sounds like Corrupted/Suspect Mirror database to me...(I could be wrong)

Any traces of Storage Issues,Network issues on your Mirrored server or...

Did you worked with your Domain admins to verify the entries(CNOs and/or VCOs) in DNS? Looks like your domain already has a SQL Server Instance with the same name which...

Not sure why you would want to change a working key which has been already licensed...As long as you've purchased license(it's just paper work) to use standard eiditon you should...

Why do you need exact syntax here?

It wont give you exact T-SQL and i don't think it's needed in your case. If it says Type as "database" and DDL...

You can simply look for the respective database recovery events in the SQL Server Error Log and keep track of them. When DB mirroring failover happens, SQL Server will perform...

Even the DBCC WITH TABLOCK option will through the same error if database have more then one connection...which might be the case here.

It's recommended to use NTFS formatted Volumes for...

1.Make sure Service account has permissions at the Root level of the Drive.

2.Check for FAT32/NTFS - If FAT32, I think you need to specify TABLOCK option(Am not 100% Sure though)

For...

Are you sure, Named Pipes, Shared Memory and TCP/IP protocols are enabled on SQL Server and it is set to run in Mixed Mode Authentication?

Krishna-Are you sure, you looked at SQL Server trace files thoroughly? As Gail already mentioned SQL Server will maintain only few trc files with 20 MB limit by default. For...

SQL Server Failover Cluster Instances are not mandatory for AGs. All you need is a Windows Cluster and standalone SQL Instances to make it work(All the Servers(nodes) participating in AlwaysON...

AFAIK, It's not possible. Installing Windows VM using Hypervisor on top of your Linux Box might help you if at all it's allowed by your OS.

When you say " I have created the same login in Instance02", are you sure you've created the login with the same SID, not just the name?

Making use of Microsoft SQL Server Migration Assistant(SSMA) for MySQL is the best bet as the starting point IMO. I used SSMA for Oracle very recently with fruitful results.

You can...

But for "BACKUP LOG DB_Name...........WITH NORECOVERY" to run successfully, SQL server needs exclusive access on the respective database right? If there's any active session in the Database, it won't let...

The SQL Log clearly shows SQL Service has been stopped because of Server Shutdown. To be able to identify what triggered this, investigate Windows logs(Application/System/Setup/Security) from Event viewer(Not just the...