how to take a db into unrecovery mode and apply more log backups?

In SQL Server Enterprise Manager, I restored a db from its full, diff and two
log backups (there are 4 log backups for this db) and left the database
operational. But I did not find what I need in the restored db. So I wanted
to apply the rest two log backups to the db. What should I do to the
currently operational db so that I can apply more log backups on it?
Thanks,
BingBing,
From your comment, I assume that you have done something in the database and
may not be able to restore old logs any longer. I believe that you needed
to do your earlier restores with the STANDBY option. As below from the BOL:
STANDBY = undo_file_name
STANDBY allows a database to be brought up for read-only access between
transaction log restores and can be used with either warm standby server
situations or special recovery situations in which it is useful to inspect
the database between log restores.
RLF
"bing" <bing@.discussions.microsoft.com> wrote in message
news:76F7D171-AE5D-4A08-A489-87A0DB186724@.microsoft.com...
> In SQL Server Enterprise Manager, I restored a db from its full, diff and
two
> log backups (there are 4 log backups for this db) and left the database
> operational. But I did not find what I need in the restored db. So I
wanted
> to apply the rest two log backups to the db. What should I do to the
> currently operational db so that I can apply more log backups on it?
> Thanks,
> Bing|||Thanks, Russell. You read me right. And STANDBY is just what I need to do.
Bing
"Russell Fields" wrote:
> Bing,
> From your comment, I assume that you have done something in the database and
> may not be able to restore old logs any longer. I believe that you needed
> to do your earlier restores with the STANDBY option. As below from the BOL:
> STANDBY = undo_file_name
> STANDBY allows a database to be brought up for read-only access between
> transaction log restores and can be used with either warm standby server
> situations or special recovery situations in which it is useful to inspect
> the database between log restores.
> RLF
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:76F7D171-AE5D-4A08-A489-87A0DB186724@.microsoft.com...
> > In SQL Server Enterprise Manager, I restored a db from its full, diff and
> two
> > log backups (there are 4 log backups for this db) and left the database
> > operational. But I did not find what I need in the restored db. So I
> wanted
> > to apply the rest two log backups to the db. What should I do to the
> > currently operational db so that I can apply more log backups on it?
> >
> > Thanks,
> >
> > Bing
>
>