You may have more sucess using the restore database wizard in SQL Server Management Studio. This way you can select the specific file locations, the overwrite option, and the WITH Recovery option.
使用下面语句来恢复到正确状态 RESTORE DATABASE [dbname] WITH RECOVERY https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/
RECOVERY_PENDING: The database is in the process of recovery but has not yet completed. SUSPECT: SQL Server has detected a problem with the database and is unable to recover it. By checking the state of your database using this query, you can determine if your database is in the recove...
USE[TSQL2012]--定义备份设备EXECsp_addumpdevice'disk','backupdevice1','d:\backup\backup_tsql2012.bak';--完整备份数据库BACKUPDATABASETSQL2012TObackupdevice1WITHNOINIT,NAME='Full Backup of TSQL2012';--插入数据INSERTINTOdbo.test(OrderID,ProductID)VALUES(1,1);INSERTINTOdbo.test(OrderID,Produ...
SELECTname,state_descFROMsys.databasesWHEREname='your_database_name'; 1. 2. 3. 如果数据库处于“RESTORING”状态,可以使用以下命令进行恢复: RESTOREDATABASEyour_database_nameWITHRECOVERY; 1. 4. 恢复时间的影响因素 恢复数据库的时间取决于以下几种因素: ...
This article describes the errors and limitations of an availability database in Microsoft SQL Server that's in a Recovery Pending or Suspect state and how to restore the database to full functionality in an availability group. Original product version: SQL Se...
SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric A database is always in one specific state. For example, these states include ONLINE, OFFLINE, or SUSPECT. To verify the current state of a database...
[298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001 [298] SQLServer Error: 9001, The log for database 'tempdb' is not available. [Microsoft][ODBC SQL Server Driver]Communication link failure [SQLSTATE 42000] (Error 50000) @@ROWC...
RESTORING(还原中):这个状态很简单,管理员正在还原该数据库,不解释 EMERGENCY(紧急):这个状态也是管理员用的,就是说明数据库有问题了,它正在尽量解决 以上几个状态中,发生在启动过程中,并且会发生问题就是上面的RECOVERY PENDING(挂起还原)、SUSPECT(质疑)、RECOVERING(恢复中): 我们依次来看: RECOVERY PENDING(挂起还...
The name of the database to be modified. CURRENT Applies to: SQL Server (Starting with SQL Server 2012 (11.x)) Runs the action in the current database. CURRENT isn't supported for all options in all contexts. If CURRENT fails, provide the database name. <accelerated_database_recovery>...