Could not open new database UFDATA_006_2020. CREATE DATABASE is aborted

File activation failure. The physical file name D:\DBServer\DbErp.ldf may be incorrect.

OurCustomer-SQLServer 【2023-08-29 09:10】

Attach Databases failed for SQLServer database:


001.png


TITLE: Microsoft SQL Server Management Studio

------------------------------


Attach database failed for Server 'jogewang2008r2'.  (Microsoft.SqlServer.Smo)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=.

Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476


------------------------------

ADDITIONAL INFORMATION:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


------------------------------


Could not open new database 'UFDATA_006_2020'. CREATE DATABASE is aborted.

File activation failure. The physical file name "D:\U8SOFT\ADMIN\cw\ZT006\2020\UFDATA_006_2020_log_new.ldf" may be incorrect.

The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database,

 or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure. 

(Microsoft SQL Server, Error: 1813)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=1813&LinkId=20476


------------------------------

BUTTONS:


OK

------------------------------


SQLServer、Oracle and MySQL database can be restored and repaired。

Wechat: jogewang80554803

Skype: jogewang

Email:jogewang@hotmail.com