zahidshah (12/9/2010)
Restore database Databasenamefrom disk='c:\backup\testbackup.bak'
with norecovery
You ran it exactly like that? You ran no other restore commands prior to the log restore? No one else ran a 'restore database with recovery' statement?
The error indicates that the database was recovered (restore with recovery) before trying to restore the log. If you're doing any restore through the gui, doublecheck that you set the option correctly, it's not the default.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability