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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2009-03-08 : 16:11:40
|
| Hello again everyone. I am trying to retore adventureworks databasewith NoRecovery for a mirroring exercise. once i have completed the recovery wizard, THe database just always says it is restoring....hours and hours.can anyone tell me why. Or it the adventureworks database so big, it will take a very long time to restore.RegardsRobMCTS certified |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-08 : 16:14:16
|
| Because you have chosen NoRecovery mode.It will allow you to add transaction log backup or Diff backups if you have done any after full backup. Implement Transaction log backup also in Norecovery mode and start Mirroring. |
 |
|
|
|
|
|
Why Restore is taking so long?