• Hi,

    I think what you may have done is to Restore the database with the 'Leave database read-only and able to restore additional transaction logs' option selected.

    This mode allows you to restore log file backups so that things like upto point-in-time recoveries are possible. (A traditional backup plan would comprise, for example, a daily complete or differential backup with an hourly log backup.)

    If this is the case you can restore the database using theT-SQL command:

    RESTORE DATABASE MyDb WITH RECOVERY

    See 'Recovering a Database Without Restoring' in Books online for more details.

    -Ed