I am trying to refresh a dev database from production.
Both systems are running SQL Server 2008 64 bit with SP2 on Windows Server 2008.
The backup of prod is done with Red Gate's SQL Backup 6.
The resulting sqb file is copied to the dev server. Because we don’t have a Red Gate license for the dev server, we use their tool sqb2mtf.exe to recreate the .bak
file and then restore using native SQL.
We have done this many times without issue.
However, today the native restore to dev is not working.
It appears to work as the progress info shows 10
View Complete Post