I am wondering if this possible, I can not seem to apply another transaction log.
I have restored the Full database backup, the differential backup and my last Transaction Log WITH RECOVERY
. If later on I need to apply the next Transaction Log in sequence to it, what do I need to do?
I tried applying the Transaction Log and it states:
The log or differential backup cannot be restored because no files are ready to rollforward.
For each time I need to add a new Transaction Log, do I have to go through the steps of restoring the backup database, restoring the differential database and all transaction logs again?