Have Geek Brain

SQL Server Management Studio takes 100% of recovery

I want to restore a bak file to SQL Server 2008 (the backup was made to SQL Server 2005). I have set recovery to WITH NORECOVERY as I will be applying further transaction logs later.

Meaning: The database should remain in recovery mode, but the recovery dialog in Management Studio does not end. It shows 100% for almost 20 hours. If I click stop action now, the restore failed.

I need to install WITH NORECOVERY (instead of WITH RECOVERY) as I want to apply the transaction logs later. What's wrong?

+2


a source to share


1 answer


The issue was addressed by installing Cumulative Update 7 for SQL Server 2008 SP1. CU 1 seems to include a fix for restoring 2005 backups on 2008 server.



+1


a source






More articles:


All Articles