• If we follow your suggestion, what we need is:

    1. We get from source at the begging a full backup and restore it destination.

    2. Everyday we get the daily log file (*.trn) from source and restore it to destination.

    The sequence seems ok. But what we need also is the destination to be online. Is this feasible ? Because, as I understand, we need to use "WITH NORECOVERY" to the first restore (from full backup) in order to be able to restore the following log files. And this brings the database to 'a restoring state', which we don't want because we need the destination to be on line.

    So, the question is how can we restore a full backup with the destination being on line after restore and then every night we restore the coming log files ?