数据库版本:SQL Server 2008 R2 (RTM) - 10.50.1600.1
备份文件版本也是:SQL Server 2008 R2 (RTM) - 10.50.1600.1
将数据库备份文件restore database到新数据库后,输出:
后一直无法完成数据库恢复工作。执行sp_who查看到恢复数据库的进程一直处于Conditional状态中。
将sql 2008 R2服务器shutdown with nowait强制关闭后,启动数据库服务器,新恢复出来的数据库test1一直无法访问,执行sp_who查看到有个访问test1的后台系统进程一直处于DB STARTUP状态中。
网上找到:FIX: Slow performance when you recover a database if there are many VLFs inside the transaction log in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
https://support.microsoft.com/en-us/help/2455009/fix-slow-performance-when-you-recover-a-database-if-there-are-many-vlf