"Joe" <J**@discussions.microsoft.com> wrote in message
news:C4F44780-38FF-4C74-B959-4EA13A633D0C@microsoft.com...
> what is the meaning for no recovery option

"Mike Epprecht (SQL MVP)" wrote:

> From BOL:
>
> NORECOVERY
>
> Instructs the restore operation to not roll back any uncommitted
> transactions. Either the NORECOVERY or STANDBY option must be specified if
> another transaction log has to be applied. If neither NORECOVERY, RECOVERY,
> or STANDBY is specified, RECOVERY is the default.
>
> SQL Server requires that the WITH NORECOVERY option be used on all but the
> final RESTORE statement when restoring a database backup and multiple
> transaction logs, or when multiple RESTORE statements are needed (for
> example, a full database backup followed by a differential database backup).
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: m***@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Joe" <J**@discussions.microsoft.com> wrote in message
> news:C4F44780-38FF-4C74-B959-4EA13A633D0C@microsoft.com...
> > what is the meaning for no recovery option
>
>
>