I have SQL Server 2012 SP4, ten databases and log shipping.
One database 2.7TB
- Ten data files and two log files
Log shipping configuration:
- Transaction log backup job : 3 Min
- Copy job : 1 Min
- Restore job : 1 Min
- Standby Mode, clicked Disconnect users...
A 50MB trn file take at 2 hours restored. The database is being 100% restored and remains. How do i solve this?