Restoring secondary backup files on primary server in sql server
0
votes
2
answers
686
views
I want to restore log backup file on copy-only full backup in restoring mode on primary replica server
these backups were taken from secondary replica .
I took copy only full back up on secondary replica then failover after that I took .trn backup file on primary replica(which took full backup ).
both full and trn file backup from one server but full backup took when server in secondary mode and trn backup took when server be in primary backup and I want to restored both of them in restoring mode on secondary replica after failover.
I wanted to add database in cluster with my hand because our databases are big
it was error when they are restored on primary server
the error is
> The log in this backup set begins at LSN 38202000004450500001, which is too recent to apply to the database.
An earlier log backup that includes LSN 38167000000015500001 can be restored.
Asked by NShyn
(1 rep)
Jan 25, 2022, 09:57 AM
Last activity: Jul 25, 2025, 10:05 PM
Last activity: Jul 25, 2025, 10:05 PM