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:
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