Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
narsireddy
Starting Member
1 Post |
 Posted - 2010-01-20 : 03:30:07
|
| can any one explain the main difference between with recovery and with no recovery in database restore |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-20 : 04:06:27
|
| NO RECOVERY leaves the database in a state where further, additional, files may be restored. The database cannot be "used".RECOVERY specifies that the restore is completed, and the database should be made ready for access as normal.Typically a FULL backup, then optionally a DIFFERENTIAL backup, then each subsequent TRANSACTION backup file is restored in sequential order using the NORECOVERY option, and then when the final TRANSACTION backup file is restored that is done using the RECOVERY option |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
with recovery