thanks for your reply, but i'm not able to understand what exactly it will do?[quote]
It will backup the database and then change the database state from ONLINE to RESTORING. In that state, no one will be able to access the database at all
[quote]what are the advantages?.
If you're backing up the log prior to a restore, you don't want any more changes to be made after the last log backup. Hence, take the log backup with NoRecovery and no one will be able to access the DB.
Other than that, pretty much no uses.
Do you have any specific links regarding this backup... with norecovery
Did you try Books Online. I know there's stuff in there on this.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass