数据库版本: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
恢复bak类型的数据库是,一直处于’正在执行(0%)'状态. 经网上搜索后,查出原因. 后用以下代码解决 USE master RESTORE FILELISTONLY FROM DISK = 'F:\QQGroup.bak' Go RESTORE DATABASE quntest FROM DISK = 'F:...
USE[master] ...ALTERDATABASE[数据库名]SETRECOVERYSIMPLEWITHNO_WAIT GO ALTERDATABASE[数据库名]SETRECOVERYSIMPLE GO USE[数据库名] GO DBCCSHRINKFILE(N'[数据库日志文件名称]',0,TRUNCAT...
The backup set holds a backup of a database other than the existing ‘XXXXX’database. RESTORE DATABASE is ... (Microsoft SQL Server,错误: 3154) 解决方法: USE MASTER --物理名称 RESTORE DAT...