SQL Server 2005 Perform “RECOVERY” on database restored with “NORECOVERY”

backuprestoresql serversql-server-2005

I have full weekly backups, daily differential backups and hourly transaction log backups.

To restore the database, I restore the full backup, then the last dif backup then all the transaction log backups specifying NORECOVERY on all the restores except the last one.

My question is. If I accidently restore my last transaction log with the NORECOVERY flag set, is there a command I can run to "RECOVER" the database at this point?

I'm using SQL Server 2005.

Best Answer

Try this (from SQL2000 help): RESTORE DATABASE dbname WITH RECOVERY