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 |
|
lionofdezert
Aged Yak Warrior
885 Posts |
 Posted - 2008-12-24 : 02:16:17
|
| I have a full backup and 3 transactional backups. But while on restoration process i mentioned RECOVERY while restoring full back up and database became live, now i realize i must also restore transactional backups. What should i do to update my database mode to NoRecovery mode, so i can restore my transactional backups.Note: No changes are made after full backup (with recovery mode) |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-12-24 : 04:51:55
|
| RESTORE the full backup again WITH NORECOVERY. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-24 : 07:29:49
|
| Restore Full backup with NORECOVERY,Restore 2 Tran log backup with NORECOVERY and last log backup with RECOVERY. |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-12-26 : 02:38:44
|
| thanx guys |
|
|
|
|
|
|
Update database to NoRecovery mode